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.
In PowerBI I'm trying to calculate last months sales. I have a slicer for the date and this is where it's becoming stuck, I think.
All data is in one table and I'm trying to essentailly calculate the sum of sales orders, if the include/exclude = Include, and the dates are one month prior to that selected on the slicer.
I've tried:
Solved! Go to Solution.
Hi @ryan_mayu .
Your answer gave me an idea and this worked:
maybe try this
Proud to be a Super User!
Hi @ryan_mayu .
Your answer gave me an idea and this worked:
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
96 | |
92 | |
91 | |
75 | |
69 |