Hello,
I should see 0 in the month of June, but as you see (blue line) - I do not see anything - the line stops in June...
The measure is here:
Incidents 2022 = CALCULATE(SUM('Issues'[Issue Y/N]),'Date Table'[Year]=MAX('Date Table'[Year]))
Incidents 2021 = CALCULATE(SUM('Issues'[Issue Y/N]),'Date Table'[Year]=MAX('Date Table'[Year])-1)
I tried to add+ 0 but it messes up my trendline...
I need to see 0 for the month of June...so far it just looks (blank) - how to replace blank with 0?
Incidents 2022 = CALCULATE(SUM('Issues'[Issue Y/N]),'Date Table'[Year]=MAX('Date Table'[Year]))+0
@Anonymous
I am not sure why you want to have 0 there.
But if your logic is to show 0 for the present month then it will be simply,
If Month=Current Month then 0 else YOUR Calculation > Incidents 2021 end/This way it will just make 0 for the current month
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users
