Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have a calculated column that returns sales for a week by area with following syntax:
Hi,
Do you have a column Sales[Day] in your Model? if not you need to create a Calendar Table.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi thanks, yes I do have a Sales[Day] column in the table and a separate calendar table and there is a relationship between the two.
So you looking to calculate the Running total!
You Either use the quick measure feature in the desktop or use this formula
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Thanks that is great but is needs to be a grouped total of the last 7 days that changes each day, i.e. on 8th November = all sales for dates 2nd - 8th November. On 9th November = all sales for dates 3rd-9th November. Can you help with that please?
Many thanks
Not sure I understand what you need! But add "-1" to the formula if that's what you are looking for
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Thanks, I appreciate your help but what I am looking for is a measure that can be plotted on a time-based chart showing 7 day sales over a rolling period. With my original code I can plot sales by week:
Sales by Area by Week = CALCULATE(count(Sales[Area]), ALLEXCEPT(Sales, Sales[Area],Sales[Week]))
But what I would instead like to be able to do is to plot the rolling number of sales by 7 day period, so for example it might be
2nd - 7th November = 10 sales
3rd - 8th November = 15 sales
4th - 9th November = 20 sales
Then on the chart, have 7th, 8th and 9th November represented by values of 10, 15 and 20.
Hope this makes sense.
Well the formulas i proposed do the exact that, But to have 7 days difference in your running total just subtract 7 days instead of 1 day in the
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |