Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am hoping that someone can help me with the DAX calculation.
What I want to do, is I want to get the total for each Year into a column, so that I can calculate the variance.
So as an example the total for Fiscal Year 2014-15 is 3,109,234 and I want to get the "Year Total Amount" as a DAX calculation. And I want it to dynamically change based on each Fiscal Year. Currently I have not found a DAX calculation in how to make it dymancially represent the total for each Fiscal Year.
I can only do it for ALL the dates. Any help or suggestions would be appreciated.
Month Fiscal Year Total Amount Year Total Amount July 2014-15 222,240 3,109,234 August 2014-15 502,727 3,109,234 September 2014-15 196,123 3,109,234 October 2014-15 246,279 3,109,234 November 2014-15 216,672 3,109,234 December 2014-15 336,935 3,109,234 January 2014-15 264,282 3,109,234 February 2014-15 232,351 3,109,234 March 2014-15 216,005 3,109,234 April 2014-15 210,155 3,109,234 May 2014-15 216,637 3,109,234 June 2014-15 248,827 3,109,234 July 2015-16 241,957 3,020,604 August 2015-16 323,376 3,020,604 September 2015-16 245,660 3,020,604 October 2015-16 307,581 3,020,604 November 2015-16 261,458 3,020,604 December 2015-16 290,593 3,020,604 January 2015-16 184,431 3,020,604 February 2015-16 196,787 3,020,604 March 2015-16 226,399 3,020,604 April 2015-16 187,208 3,020,604 May 2015-16 216,522 3,020,604 June 2015-16 338,632 3,020,604
Solved! Go to Solution.
To any one looking for the solution I figured it out.
The following DAX Syntax works
Total Amount Per Year = CALCULATE([Total Amount],ALL('Date'),VALUES('Date'[Fiscal Year]))
To any one looking for the solution I figured it out.
The following DAX Syntax works
Total Amount Per Year = CALCULATE([Total Amount],ALL('Date'),VALUES('Date'[Fiscal Year]))
hi
this dax doesnt work for me. could u please help post the dax with real example that works for u ? thanks
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |