Forum Discussion

tbezui3's avatar
tbezui3
Frequent Visitor
4 years ago
Solved

Calculation

Hi everyone  What can we use in powerbi to get the same result as In tableau when we use the below?    Tableau calculation [Calldate]={ FIXED [uniqueidentifier]:MAX([Calldate])}
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi  tbezui3 

    If you want to find their respective maximum Calldate according to uniqueidentifier, you can try this way,

    create a measure (see sample file attached below)

     

    Measure = CALCULATE(MAX('Table'[Calldate]),ALLEXCEPT('Table','Table'[uniqueidentifier]))

     

    also, here is a same post for your reference, 

    Calculation Fixed:MAX - Microsoft Power BI Community

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi  tbezui3 

If you want to find their respective maximum Calldate according to uniqueidentifier, you can try this way,

create a measure (see sample file attached below)

 

Measure = CALCULATE(MAX('Table'[Calldate]),ALLEXCEPT('Table','Table'[uniqueidentifier]))

 

also, here is a same post for your reference, 

Calculation Fixed:MAX - Microsoft Power BI Community

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.