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.
Working with time periods, I have what I want for the past, but how can I add in future? Looking for Next 90 days, etc
Current dax
The dax above is working as intended. Ideally I would like to be able to add to this dax to also get a selection in the column for the next 90 days, next 6 months, and next year. In our business we enter orders in to our ERP and alot of our business is in the future, so this would help us with projecting for time periods. Thanks!
A rolling time period would be helpful too!
User | Count |
---|---|
65 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
120 | |
41 | |
40 | |
28 | |
23 |