Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
User | Count |
---|---|
85 | |
75 | |
71 | |
69 | |
55 |
User | Count |
---|---|
98 | |
96 | |
92 | |
78 | |
70 |