Forum Discussion
GilbertQ
Super User
Super UserYear Total in Column for Each Year
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 ...
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]))
GilbertQSuper User
Super UserTo 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