I am trying to identify which of my clients paid me something last month but did not pay me anything this month.
I have written a DAX measure to show me the revenue i obtained last month and I have another DAX measure that shows me the revenue for this month.
Currently I am using a filter (Page/Report Filter) to identify the comparison
I wanted to know if I could write a measure that does the comparison for me as opposed to using page/report filters?
If it is possible, how would i go about achieving this?
Last Month = CALCULATE([This Month],DATEADD(Dates[Date],-1,MONTH))
This Month = CALCULATE([PH Revenue],FILTER(VALUES('Master Commissions'[Revenue Type]), COUNTROWS(FILTER('Revenue Streams','Master Commissions'[Revenue Type]='Revenue Streams'[Revenue Groups]))), FILTER(VALUES(Clients[Client Entity]), COUNTROWS(FILTER('Master Commissions',Clients[Client Entity]='Master Commissions'[Entity ID]))))
Thanks in Advance!!