Forum Discussion
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])}
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.
2 Replies
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/38490Hi 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.
