Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, IM trying to build a measure that a report end date is set (Eg 31 May 2023). Measure will grab monthly actuals before or equal to report end date and than after pull monthly forecast data. I have built an Actuals measure and now trying to apply a filter so it only returns Jan to May actuals. It shows the May amount and correct total but Jan to April are blank? Tried both a calculate and sumx functions as per below. Any idea why the months prior to May are not showing?
Solved! Go to Solution.
@GSMAUSSIE
Your TEST measure should work as long as you have your model properly setup. Please check the testing I just did wheren I have a disconnected 'Dates 2' Table to select the date and I used MAX as I have between slicer.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Fowmy OK Thanks! My ReportDate paramter was also connected to the Calendar dimension table. When i disconnected the relatinship it now works fine! Thankyou!
@GSMAUSSIE
Your TEST measure should work as long as you have your model properly setup. Please check the testing I just did wheren I have a disconnected 'Dates 2' Table to select the date and I used MAX as I have between slicer.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |