Forum Discussion
Solved
Subscription Purchase reduction or cancellation DAX
Hi all, I've got a question regarding what I can do in Power BI to determine subscription cancellation and module reduction. UPDATE: You can download the sample PBIX file here from DropBox. ...
Hi,
I see no difference between the Invoice and InvoiceItem table. WIth the relationship established correctly, you just have to edit all my measures to refer to the Invoiceitem table (rather than the Invoice Table).
Please try that yourself.
Hi,
Try this measure
=SUMX(FILTER(SUMMARIZE(VALUES(Invoice[Customer_ID]),[Customer_ID],"ABCD",[Subscriptions],"EFGH",[Subscriptions in previous month]),[ABCD]>0&&[ABCD]<[EFGH]),[EFGH]-[ABCD])
Hope this helps.
You are welcome.