Stuck on measure, end of previous month

[Anonymous]

Hi all,

I have a measure that I took from the forum a few months back, I am stuck now at adapting it slightly.

I need it to hide dates AFTER the last day of the previous month. I have tried to do a dateadd but this will not get to the end of the previous month 😞

I am pretty stumped, does anyone have any ideas?

Code:

var __currentMinDate = min('Calendar'[Date])

var __today = today()

var __cumulativeValue = CALCULATE(COUNT('TableSales'[Type]),DATESYTD('Calendar'[Date])) + 0

var __shouldDisplay =

     -- check if the current period is

     -- fully contained in the future

    NOT ( __currentMinDate >= __today )

return

    if( __shouldDisplay, __cumulativeValue)

[Anonymous]

that is perfect, thank you 🙂

[parry2k · Accepted solution]

@Anonymous try this

var __currentMinDate = min('Calendar'[Date])
var __today = today()
VAR __prevMonth = EOMONTH ( __today, -1 )
var __cumulativeValue = CALCULATE(COUNT('TableSales'[Type]),DATESYTD('Calendar'[Date])) + 0
    
var __shouldDisplay =
     -- check if the current period is
     -- fully contained in the future
    NOT ( __currentMinDate >= __prevMonth )
return
    if( __shouldDisplay, __cumulativeValue)

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.⚡