Need help to identify if a date is month to date

[Alanlu]

Hi guys,

Have encountered some issue to identify if a date is within the MTD range:

the max date is 30-Sep-2022, but 1-Jul-2022 still identified as MTD true, which part is wrong in my formular?

thanks all

[wdx223_Daniel · Accepted solution]

try to change the code of currentWorday as this

CurrentWorkday=CALCULATE(MAX('sales'[Posting Date]),'sales'[CY rev]<>0,REMOVEFILTERS())

[Alanlu]

Thanks Daniel! works perfectly! 😉