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.
I have created a calculated column 'CumulativeTotalColumn' using this dax formula:
CumulativeTotalColumn = var rowdate = Journals[JournalDate] Return CALCULATE( SUM(Journals[Total]), FILTER( 'Journals', 'Journals'[JournalDate]<= rowdate) )
The result:
Now, I need another calculated column, 'CalculatedTotalColumnShifted' that shifts the 'CumulativeTotalColumn' down by one row. i.e. 1st March 2016 has the CumulativeTotal of 29 Feb, 2nd March has the Cumulative Total of 1st March and so on.
Any ideas?
Thank You
Solved! Go to Solution.
Hi, you can obtain with this
CumulativeTotalColumnShifted = var rowdate = Journals[JournalDate] Return CALCULATE( SUM(Journals[Total]), FILTER( 'Journals', 'Journals'[JournalDate]< rowdate) )
Hi, you can obtain with this
CumulativeTotalColumnShifted = var rowdate = Journals[JournalDate] Return CALCULATE( SUM(Journals[Total]), FILTER( 'Journals', 'Journals'[JournalDate]< rowdate) )
@Vvelarde. Wow, I didn't realize that. I am very new to DAX. But, glad that the community members are very helpful.
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |