Tableau function into Power BI DAX

[Paatridepaul]

How to do this Tableau function: window_avg_max_distancia = {FIXED [Trayecto]: (MAX([TravelDist_km])

[v-tangjie-msft · Accepted solution]

Hi @Paatridepaul ,

To translate the Tableau function into Power BI DAX, you can use the function with to achieve a similar result. Here's an example DAX expression:

Window_Avg_Max_Distancia = CALCULATE(MAX('Table'[TravelDist_km]), ALLEXCEPT('Table', 'Table'[Trayecto]))

Best Regards,

Neeko Tang

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

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...