Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Team, I have three tables showing weekly forecast, capacity, and plan by discipline, Project, and Grouping. I've created measures for the Average of the Top 5 weeks (for Forecast) and Max of Capacity (for capacity). These are working fine with slicers on the page except the slicers for Office Location and Approval. Office Location and Approval are fields from the forecast table. I need help with the following:
Can you plz guide me?
Solved! Go to Solution.
For the 1st Problem - you can change the following Measure to
Proud to be a Super User! | |
Proud to be a Super User! | |
ForecastTable[Week]<=TODAY())
above expression will consider all records that are less than equal to today
If you want to do it by DAY,Month,YEAR, you can use
Proud to be a Super User! | |
Thanks @Kaviraj11 this is working as required.....I wanted dates after today so I just changed the "less than" to greater than.
Can you explain with an example?
I would also recommend to create a DateDim or Calendar table.
Could you mark first solution as accepted?
Proud to be a Super User! | |
I want the AvgTop5Weeks measure to calculate the average of top 5 weeks which are after a specified date. Currently it is calculating the average of top 5 weeks among all weeks listed in the table. Example, let's say I want the average of Top 5 weeks which are after week 28th March.
Proud to be a Super User! | |
In above, where and how do I specify the date after which I want the measure to calculate the average?
ForecastTable[Week]<=TODAY())
above expression will consider all records that are less than equal to today
If you want to do it by DAY,Month,YEAR, you can use
Proud to be a Super User! | |
Thanks @Kaviraj11 this is working as required.....I wanted dates after today so I just changed the "less than" to greater than.
For the 1st Problem - you can change the following Measure to
Proud to be a Super User! | |
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
105 | |
99 | |
99 | |
38 | |
37 |
User | Count |
---|---|
156 | |
121 | |
73 | |
73 | |
63 |