Forum Discussion
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...
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
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
Hi Ryan_mayu,
I still need your support the solution works so far but now I am facing the issue that when summarizing the values I am getting the Max Value of the analyzed dimension.
See in your example Value D = 60 and the Total result is also 60.
Is there a way to sum or to calculate the average of the values? In our case Total =47,5
you can create another measure
Measure 2 = AVERAGEX(VALUES('Table'[Attribute]),[Measure])Thanks a lot just figured it out last night 😅
Step by step I am getting into it