Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Calculation difference between Power BI and Excel

Hello!! How are they? I hope well. I wanted to know if you can help me with a case where I do not understand where the problem would be, I pass the context: I have a table called Tons, which has th...
amitchandak's avatar
amitchandak
Super User
2 years ago

Syndicate_Admin , Have separate table with values exercise

 

an try like

 

New measure =
var _max = MAX(exercise[exercise])
var _min =_max-4
RETURN
calculate(
AverageX(summarize(tonnes,Tons[Id]) CALCULATE (SUM(tonnes[tonnes]) )), filter( all(exercise), exercise[exercise] >=_min && exercise[exercise] <=_min))

 

 

Consider window function if needed

 

Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f