When sales is blank, I want to see month with 0 value. I tried to make a report in Power BI with sales month by month for the last 20 months, however when sales is blank, I want to see month with 0 value.
I chose to replace all Blank() values with 0 and add a 0 at the conclusion of the calculation.
It works fine, however I'm having trouble with the date hierarchy limitation because my chart now has a lot of months with no value (first value begins in 2017, date hierarchy first value begins in 2000).
SUM( quantity ),
flag = 1,
title = "WEEKS"
) + 0