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.
Hi all
could someone kindly propose a suitable DAX alternative (for PBI) to the below formula in Excel ?
=IF([@CompleteBy] = "", "NA",IF([@CompletedDate] >[@CompleteBy],"Overdue", IF(AND([@CompleteBy] < TODAY(),[@CompletedDate] =""),"Overdue","Not Overdue")))
Thanks in advance
Solved! Go to Solution.
Hi @Anonymous ,
You can create a calculated column as below:
Overdue =
IF (
ISBLANK ( 'Table'[CompleteBy] )
&& 'Table'[Status] <> "Overdue",
BLANK (),
IF (
'Table'[CompletedDate] > 'Table'[CompleteBy],
"Overdue",
IF (
'Table'[CompleteBy] < TODAY ()
&& ISBLANK ( 'Table'[CompletedDate] ),
"Overdue",
"Not Overdue"
)
)
)
Best Regards
@Anonymous , Create a new column like
if(isblank([CompletedDate]) && [CompleteBy] <today(), "Overdue","Not Overdue")
Thanks but not quite working yet...
Overdue = IF(Table 1[Status] = "Overdue", "Overdue", IF(ISBLANK(Table 1[CompletedDate] && Table 1[CompleteBy].[Date] < TODAY()),"Overdue","Not Overdue"))
Where i have a Completeby date in the past, it is still showing as "Not Overdue"... any ideas?
thanks
Hi @Anonymous ,
You can create a calculated column as below:
Overdue =
IF (
ISBLANK ( 'Table'[CompleteBy] )
&& 'Table'[Status] <> "Overdue",
BLANK (),
IF (
'Table'[CompletedDate] > 'Table'[CompleteBy],
"Overdue",
IF (
'Table'[CompleteBy] < TODAY ()
&& ISBLANK ( 'Table'[CompletedDate] ),
"Overdue",
"Not Overdue"
)
)
)
Best Regards
Covering 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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |