Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Please try this expression
Diff_in_days =
VAR retail_notify =
MAX ( 'Outages'[Date B] )
VAR interuption_start =
MAX ( 'Outages'[Date A] )
RETURN
IF (
YEAR ( retail_notify ) > 1900,
DATEDIFF ( interuption_start, retail_notify, DAY )
)
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Please try this expression
Diff_in_days =
VAR retail_notify =
MAX ( 'Outages'[Date B] )
VAR interuption_start =
MAX ( 'Outages'[Date A] )
RETURN
IF (
YEAR ( retail_notify ) > 1900,
DATEDIFF ( interuption_start, retail_notify, DAY )
)
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@Dunner2020 , Try like
Diff_in_days =
Var retail_notify = MAX('Outages'[Date B])
Var interuption_start = MAX('Outages'[Date A])
RETURN
CALCULATE( DATEDIFF(retail_notify,interuption_start,DAY), FILTER('Outages and Interruptions',not(isblank(retail_notify)) && retail_notify <> DATE(1900,01,01))
)
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |