Calculation

[tbezui3]

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])}

[v-xiaotang · Accepted solution]

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.

[parry2k]

@tbezui3 you need to explain what this tableau function does? Not necessarily people know how tableau formula works. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490