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
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...