Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

getting measure value by last date

Hi I am trying to get value of my measure vor latest day only. My idea was  something like following but LASTNONBLANK cannon be used in this context. Is there a way to crate something like this from measure?




CALCULATE([Total Net Revenue Contribution Margin [#]]],'Financial Contribution Margin'[Date]= LASTNONBLANK('Financial Contribution Margin'[Date],[Total Net Revenue Contribution Margin [#]]])) 

 

 

 

  • Anonymous's avatar
    Anonymous
    7 years ago

    I solved it like this at the end. It is working great. Thanks for sugestions :)

    CALCULATE([Total Net Revenue Contribution Margin [#]]]
    ,FILTER('Calendar'
    ,'Calendar'[Date]= MAXX(FILTER('Financial Contribution Margin', NOT ISBLANK([Total Net Revenue Contribution Margin [#]]])),'Financial Contribution Margin'[Date])
    )
    )

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous,

     

    Please try this measure:

    CALCULATE([Total Net Revenue Contribution Margin [#]],'Financial Contribution Margin'[Date]= CALCULATE(MAX('Financial Contribution Margin'[Date]),ALLSELECTED('Financial Contribution Margin')) )

     

    For more advice, please provide sample data and desired result.

     

    Regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I solved it like this at the end. It is working great. Thanks for sugestions :)

      CALCULATE([Total Net Revenue Contribution Margin [#]]]
      ,FILTER('Calendar'
      ,'Calendar'[Date]= MAXX(FILTER('Financial Contribution Margin', NOT ISBLANK([Total Net Revenue Contribution Margin [#]]])),'Financial Contribution Margin'[Date])
      )
      )