SUM(Job Data[Amount]) is working to get the sum from my Amount column. I use it for a Lifetime earnings view. Whatever amount is placed in that column gets calculated. However, I would also like to have a Current year View without specifying dates. So whatever calendar year it is, I want that total to show from that “Amount” data. I thought this might work… SUM(Job Data[Amount])Current Year, but it does not. Can anyone give me the answer?
Please take a look at the following functions to build the necessary expression.
1 Like