Forum Discussion

jananagarajan's avatar
jananagarajan
Regular Visitor
3 years ago
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       ...
Need Help
Tips and Tricks
  • komald's avatar
    komald
    3 years ago
    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
komald's avatar
komald
Helper I
3 years ago
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
jananagarajan's avatar
jananagarajan
Regular Visitor
3 years ago

Thank you Komald.