Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi - I used this formula from a previous solution from @v-lionel-msft to pull in difference between two columns instead of total, but I am having issues adding a second filter.
We are using this to show revenue change over import dates in our production schedule, and I am wondering how I can edit this formula to allow additional filtering by both import date, and planned end date.
Here is the current formula:
The formula works when filtering by one column "import date":
But when I try to filter by the month end date, it gives me this:
Is there another clause I need to add to allow filtering by both import date and planned end date?
The goal is for the end user to select two import dates and a month, then for the the matrix to display customer, both import dates and the difference in revenue between those two columns, only for the month that was selected.
Any help is greatly appreciated.
Solved! Go to Solution.
Figured it out!