Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
Are three any good examples with DAX Date Calculations for the following:
1. Have a Year Month Slicer.
2. When there is no selection in the Year Month Slicer default to the current Year Month
3. Allow the user to select a Year Month (Jan-2023) and then use the Year Month in all the Calculations
Thank You,
Michael
Solved! Go to Solution.
This is the standard pattern for your request:
- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app
This is the standard pattern for your request:
- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |