Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Here's what I tought of doing to get the rolling 12 months sales from 2020 (sale 12 months period of last year)
I want it so i can use my relative date slicer
This keep returning me the same sales of the current year and not the 12 months before....
I know it's just a problem of my date because if i change the VAR i created for a date (like :
here's the code
Hi @PeterVachon,
Is your issue solved?
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
My Other test seems give me this error (i did some test with a card in my dashboard i am able to get the proper dates now (the all filter is skipping my selection in my slicer which is causing problem) . but when i try this version i get this
Hi @PeterVachon
Could you provide sample data and expected output after removing sensitive data?
Sample data and expected output would help tremendously.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
I won't provide no sorry.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |