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.
Hello, I'm new to DAX and have questions on getting the data for the "Previous Customised time period", I was wondering if anyone can please help?
I have the matrix below showing the average and can be sliced by the "Year+Semester" column. What I would like to have is a Measure / Column to show the data for the Previous "Year+Semester".
This is the matrix with slicers:
This is what I want to achieve, for example, when selecting 2011-2, a measure would show 2011-1 data:
Thank you very much!
Solved! Go to Solution.
Hi,
I am not sure how your dataset looks like, but I tried to create a sample pbix file like below.
Please check the below and the attached file.
All measures are in the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your dataset.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you very much. That solves my problem!
Hi,
I am not sure how your dataset looks like, but I tried to create a sample pbix file like below.
Please check the below and the attached file.
All measures are in the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your dataset.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
52 | |
27 | |
24 | |
13 | |
9 |
User | Count |
---|---|
74 | |
58 | |
47 | |
16 | |
12 |