Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

MAX Date filter

Good Day, I have an issue where a DAX formula is not ouputting correctly. Essentially I wrote formulas to calculate the value difference of items from a previous month, which ouputs correctly. Now I...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try like

measure =

VAR CurrentYearMonth = MAXX(ALLSELECTED('tertiary vw_insights_ageing_profile'),'tertiary vw_insights_ageing_profile'[Date Link])
Return

   IF(format(max('tertiary vw_insights_ageing_profile'[Date Link]),"YYYYMM") = format(CurrentYearMonth,"YYYYMM"),1,0)

 

You can use today() in place of MAXX(ALLSELECTED('tertiary vw_insights_ageing_profile'),'tertiary vw_insights_ageing_profile'[Date Link]) , if needed

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak 

I've written it exactly as you typed and it is unfortuantely still not working.

 

Perhaps the attached PBI file might be of some use ?