Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Hi @DevonVanDam ,
We could try to create measure using following formula and put into a table visual with a ID field to meet your requirement:
OverDueDay = IF ( AND ( MAX ( 'Table'[DueDay] ) < MIN ( 'Calendar'[Date] ), OR ( MAX ( 'Table'[ClearDay] ) < MIN ( 'Calendar'[Date] ), ISBLANK ( 'Table'[ClearDay] ) ) ), MIN ( 'Calendar'[Date] ) - MAX ( 'Table'[DueDay] ), BLANK () )
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @DevonVanDam ,
We could try to create measure using following formula and put into a table visual with a ID field to meet your requirement:
OverDueDay = IF ( AND ( MAX ( 'Table'[DueDay] ) < MIN ( 'Calendar'[Date] ), OR ( MAX ( 'Table'[ClearDay] ) < MIN ( 'Calendar'[Date] ), ISBLANK ( 'Table'[ClearDay] ) ) ), MIN ( 'Calendar'[Date] ) - MAX ( 'Table'[DueDay] ), BLANK () )
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you want to do this in DAX, you can use DATEDIFF() in a calculated column.
In Power Query, you just add/subtract dates from each other. [Date1] - [Date2] for example, then format that type as a whole number.
In both cases, you just follow up with an IF() statement (or if then else in PQ if you want to do it there to minimize DAX calculations in the portal) to determine if it is past due or not. I don't think your slicer is relevent in this calculation unless I am missing something. It will simply show/hide data based on the slicer selection.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |