SUM() vs SUMX(): What is the difference between the two DAX functions? 01-20-2023 01:42 AM SUM() vs SUMX(): What is the difference between the two DAX functions? Solved! Go to Solution. Labels: General Comment Interesting Links Message 1 of 10 70,084 View...
I have the same issue, i'm trying to calculate dynamicly the different of the revenue between the fiscal month selected by the user and the previous month of selected month. Please find below an example of what i want to do: New_Measure=SUMX(FILTER(MyTable;Month=Selected Month);...
Ext Cost Previous Month = CALCULATE([Ext Cost Sum], PREVIOUSMONTH('Date'[Date])) When I try to insert the number into a table nothing appears. My value for the difference between months is the same as the current month which is another indication that the previous month calculation is not...