cumulatief meting

[ArienLans2020]

ik heb een meting gemaakt en die ziet er als volgd uit

Uren eigenwerk = (BEREKEN (som (arbeid [Uren]) - BEREKENEN (arbeid [uren draaien])))

nu wil ik van deze formule een cumulatieve berekening maken maar dat lukt niet normaal gebruik ik deze code

cumulatief kosten totaal = BEREKENEN (som (arbeid [uren eigenwerk]); FILTER (ALL (arbeid [Week]); arbeid [Week] <= MAX (arbeid [Week])))

 hoe zou ik dat op kunne lossen?

MVG

Arien

[Anonymous]

English please.

Best
D

[ArienLans2020]

I have make this measures

Uren eigenwerk = (BEREKEN (som (arbeid [Uren]) - BEREKENEN (arbeid [uren draaien])))

now i want to combine this measurement with the cumulative measurement

cumulatief kosten totaal = BEREKENEN (som (arbeid [uren eigenwerk]); FILTER (ALL (arbeid [Week]); arbeid [Week] <= MAX (arbeid [Week])))

  how do I do this

Arien

[Anonymous · Accepted solution]

Creating cumulative measures is easy when you have a correct model. A correct model is a star/snowflake schema where there is at least one date dimension. You don't seem to have it. I can see that all your data is stored in one big table. Here is something to get you started on the way to a correct model:

https://www.youtube.com/watch?v=_quTwyvDfG0
https://www.youtube.com/watch?v=78d6mwR8GtA

And here is how to do time-intelligence in DAX:

https://www.sqlbi.com/tv/time-intelligence-in-microsoft-power-bi/

This is a good start. Please watch it and try to apply to your problem.

Best
D