Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I just want to figure it out how to cumulate the sum of Turnover by weeks please?
In other word, I would like to create this graph :
x = Weeks by one year
y = Turnover
But, what is the formula to create this cumulating turnover?
Start date : it depend on the selection "Date" in the timeline
End date : Like below, it depend on the timeline
Here is the graph :
Thank you a lot for your answer and have a good day !
Lena
Solved! Go to Solution.
Hi @LD1 ,
For this you can check what are your first and last dates for each data point and then calculate the measure in the 'datesbetween'. Please check an example below that I created based on your scenario:
Cumulative Value =
VAR _min_date = CALCULATE(MIN('Table Name'[Date]), REMOVEFILTERS('Table Name'[Week]))
VAR _last_date = MAX('Table Name'[Date])
RETURN
CALCULATE(
SUM('Table Name'[Value]),
DATESBETWEEN('Table Name'[Date], _min_date, _last_date),
REMOVEFILTERS('Table Name'[Week])
)
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
Best regards,
Joao Ribeiro
Hi @LD1 ,
For this you can check what are your first and last dates for each data point and then calculate the measure in the 'datesbetween'. Please check an example below that I created based on your scenario:
Cumulative Value =
VAR _min_date = CALCULATE(MIN('Table Name'[Date]), REMOVEFILTERS('Table Name'[Week]))
VAR _last_date = MAX('Table Name'[Date])
RETURN
CALCULATE(
SUM('Table Name'[Value]),
DATESBETWEEN('Table Name'[Date], _min_date, _last_date),
REMOVEFILTERS('Table Name'[Week])
)
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
Best regards,
Joao Ribeiro
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |