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.
Evening,
Hoping not to difficult a question for some talented PowerBI Guru's.
I am trying to calculate the distinct count of orders for the last 6 months and the last 6(7) to 12 months, so that is a rolling figure and always the last 0 to 12 months in two seperate calculated measures but effectivly a rolling sum of orders for the last 12 months.
At the moment i have a measure for the previous Fiscal year like the below;
Orders in 2014 = CALCULATE(DISTINCTCOUNT('Table'[OrderColumn]), DATESBETWEEN('Table'[DateColumn], DATE(2013, 10, 01), DATE(2014, 09, 30)))
But thinking a rolling average would be better so it adapts as the market changes rather than basing targets on a static previous 3 years when the last 6/12 months is the most relevant to project the next 6 to 12 months.
Thanks in Advance,
J
Solved! Go to Solution.
Think ive just cracked it...
Dist Orders Last 6 months = CALCULATE(DISTINCTCOUNT('Table'[OrderColumn]), DATESINPERIOD('Table'[DateColumn], TODAY(), -6, MONTH))
Added the - and remove the ""
Just validating the output now manually.
Thanks,
J
Think ive just cracked it...
Dist Orders Last 6 months = CALCULATE(DISTINCTCOUNT('Table'[OrderColumn]), DATESINPERIOD('Table'[DateColumn], TODAY(), -6, MONTH))
Added the - and remove the ""
Just validating the output now manually.
Thanks,
J
Hi @Anonymous,
Great to hear the problem got resolved! Could you accept your helpful replies as solution to help others who may also have the similar issue easily find the answer and close this thread?
Regards
This is what i have so far, but just returning a Null value...
Dist Orders Last 6 months = CALCULATE(DISTINCTCOUNT('Table'[OrderColumn]), DATESINPERIOD('Table'[DateColumn], TODAY(), "6",MONTH))
*Table and Column names changed*
Hoping im missing a () somewhere and nothing to major.
Thanks,
J
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 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |