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 , Not checked your file. But you can have measure like ?

 

measure =
var _max = maxx(allselected(Date), Date[Date])
return
calculate([Value measure], filter(Date,Date[Date]= _max))

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi amitchandak,

     

    Slightly confused on the [Value measure] syntax - is that self-referencing ?

     

    I tried to do it this way to get my latest month to run a filter but it does not work. 

     

    Latest Month =


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

     

    • 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 ?