Forum Discussion

BhagatRansi's avatar
BhagatRansi
Frequent Visitor
5 years ago
Solved

MaxDate per Value

Hi everyone,   I am bit in a challenge. I am receiving a table where measures a different frequencies. Some are delivered on a monthly base and some on random dates. The client like to see the most...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    BhagatRansi 

    1. select date and orgnization column and unpivot other columns in PQ

    2. create two measures

    maxdate = MAX('Table'[Date])

Measure = MAXX(FILTER('Table','Table'[Attribute]=max('Table'[Attribute])&&'Table'[Date]=max('Table'[Date])),'Table'[Value])

     please see the attachment below

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey BhagatRansi ,

 

I guess you need anyway a new measure for each Value.

The following should work:

Last Value A = CALCULATE( SUM( myTable[Value A], myTable[Date] = MAX( myTable[Date] ) )

 

Let me know if that works for you.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • BhagatRansi's avatar
    BhagatRansi
    Frequent Visitor
    5 years ago

    Thanks for your reply this solution does not work as MAX cannot be used as filter expression in the Calculate formula