Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!! hope you can help me! 🙂
I want to create a slicer which filters with the "User Selection" column from the following table called 'Slicer Period Table'
When the user selects Last Month, Last Qtr or Last Yr, the value that i want to get are the ones in the column "Month index", so i created this measure:
Then I want to calculate some measures that are filter by this slicer, like this:
I will always have the amount of sales up to two months before the current day. (For example if we are on April 2021, the last sales I have are from February 2020). Thats why the month index in the 'Slicer Period Table' don´t make sense.
Solved! Go to Solution.
Hello, yes you can do this. Heres a link to a very detailed description which I have used lots of time. Its even got a downloadable example.
Hello, yes you can do this. Heres a link to a very detailed description which I have used lots of time. Its even got a downloadable example.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |