Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |