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 ...
  • 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])
    )
    )