Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello folks,
I need assitence by a Dax question:
I have a Date and a fact table (contains forecast data) which has a 1:n relationship from the Date to the fact table.
I Need a measure, that calculates the forecast amount from the Start and the next 90 days.
This is Not the Problem, but the Report has a time slicer. If i filter the actual month with the slicer, the measure calculates only the Facts, which are between the time Range. How can i tell the Filter, that the time Range is created then the Filter?
Thanks
Hi,
Share a dataset and show the expecte result.
Hi,
Your question is not clear. What is your expected result?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 35 | |
| 33 | |
| 32 | |
| 27 |
| User | Count |
|---|---|
| 136 | |
| 96 | |
| 77 | |
| 67 | |
| 65 |