Forum Discussion
Ytd calculation missing values
Hi all, I need your help to figure out how to calculate the sum or the count of the rows where YTD calculation is equal 0. The problem is that in the fact table I have missing periods (year-month)...
BI-1294 , If you have created a date table and marked that as date table and use month year from there in visual.
I am not sure about the need for crossjoin. It should be like
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw
Yeah I know, I have no problems to calculate the YTD.
What I need is an additional measure to return 1 if the YTD quantity is = 0.
As it shows my measure is able to return 1 only in January and not in February (where I still have 0 in the YTD quantity)