Don't show a value when last month is zero or empty

[AGG_AlticeDo]

Hi!

I created the following meassure:

Test =

var LastMonth= CALCULATE([sample meassure],DATEADD('CALENDAR'[Date],-1,MONTH))

var CurrentMonth = [sample meassure]

return

CurrentMonth-LastMonth

What i would like to do is that IF LastMonth is equal to zero or is empty, then don't return any value. i am using these meassures in a matrix with months as rows.

[Ashish_Mathur]

Hi,

Try these measures

LastMonth= CALCULATE([sample meassure],previousmonth('CALENDAR'[Date]))

Test = if(isblank[lastmonth],blank(),[sample meassure])

Hope this helps.

[parry2k · Accepted solution]

@AGG_AlticeDo try this

est =
var LastMonth= CALCULATE([sample meassure],DATEADD('CALENDAR'[Date],-1,MONTH))
var CurrentMonth = [sample meassure]
RETURN
IF ( LastMonth == BLANK() || LastMonth = 0, BLANK(), CurrentMonth-LastMonth )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[AGG_AlticeDo]

Thank you so much, it works!!!