Forum Discussion
Solved
DAX Calculation Power BI
How to get the Value based on Max(Temp) in the column . Sample data is attached Customer ID Temp Value T01 39.7 55 T01 38 58 T01 37.8 58 ...
- jananagarajan , you can try,
create calculate column or measure,
output= CALCULATE(VALUES('Table'[value]),'Table'[Temp]=max('Table'[Temp]))
let me know is this work for u or not.Thanks
Actually From the Table I need to get the value based on the maximum temp in the column. From the data Max(Temp) is 42.3 then that respective value is 59. I need to write the DAX calculation for this.
Thank you
jananagarajan , you can try,
create calculate column or measure,
output= CALCULATE(VALUES('Table'[value]),'Table'[Temp]=max('Table'[Temp]))
let me know is this work for u or not.Thanks
create calculate column or measure,
output= CALCULATE(VALUES('Table'[value]),'Table'[Temp]=max('Table'[Temp]))
let me know is this work for u or not.Thanks
jananagarajan , if i answer you question please mark as a solution
Thank you Komald.