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.
Hello All,
I have reached the end of my capabilities it seems. I have an urgent request for help in creating DAX. In essance the user specifies a date range and if the contract is in that date range add that contract to the display and show Contract Name, Total Price, Annual Cost. I have thought about making a list of months/years betwen FromDate and ToDate and another list of months/years between RequestedStartDate (RSD) and RequestedEndDate(RED) and using some sort of IF is in function, but haven't gotten very far down that road yet.
The logic I am trying to create in DAX is as follows:
(not really sure how to capture this either, I have tried using the Date Range slicer based on a date table not connected to anyother table but SELECTED or SELECTEDVALUE [Start] and [End] doesn't seem to work)
Contract Name | Payment Schedule | Total Price | Annual Cost | From Date | To Date |
Widgets | Annual | 60,000.00 | 60,000.00 | 7/15/2019 | 7/15/2020 |
Gizmos | Annual | 80,000.00 | 20,000.00 | 6/01/2018 | 6/01/2021 |
Do-Dads | Full Payment | 200,000.00 | 0* | 01/01/2016 | 01/01/2021 |
*0 will show if RSD.year is after FromDate.year else Total Price will be shown
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
37 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
32 | |
28 | |
24 | |
24 |