I am trying to calculate the Revenue- Expense using DAX but i am not sure how to proceed with it. The data is in the following format :
Any help will be appreciated. Thanks in advance!
I would do a Fill Down in your Custom column in Query Editor and then you should be good to go. Before you do that, get rid of the blank lines.
Proud to be a Datanaut!
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!