The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Dear Community.
I am trying to cumulate a quantity column based on months. I am able to get the qty's to cumulate from 1 to 12 (Jan-to-Dec).
What I want to do is have the cumulation start with month 10 (Oct) and run to 9 (Sep). I have another column I created that ties the month to order. I set the order but it still is not working.
Here is how I calculated the total:
Hi @Gdibbs
DATESYTD has a second argument for year-end. (This is making the assumption that you are using a date table.)
Cumulative Quantity =
CALCULATE(
[Total Quantity],
DATESYTD( 'Date'[Date], "09/30" )
)
Thank you very much. I will be trying this over the weekend with a dates table.
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |