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.
Need help with the measure below. Looking to create a calculated column that will show either Yes or No dependent on if status is ="In Progress" and if the due date is less than TODAY then mark Yes, otherwise No. Also IF the DueDateTeamMember is blank, then also leave the OverdueDudeDateTeamMember blank
calculated column I have thus far:
Status | DueDateTeamMember | OverdueTeamMember? |
In Progress | ||
In Progress | 12/8/2021 | No |
In Progress | ||
In Progress | 12/10/2021 | No |
In Progress | ||
In Progress | 12/1/2021 | Yes |
Draft | ||
Draft | ||
Draft |
Solved! Go to Solution.
I have come to rely on the Switch Statement in DAX. I find it easier to track multiple conditions.
The following may not be exactly correct, but should get you close.
OverdueTeamMember = SWITCH(
TRUE(),
ISBLANK(DueDateTeamMember)=TRUE, Blank(),
x-Coaching-Sharepoint'[Status]="In Progress" &&
'x-Coaching-Sharepoint'[DueDateTeamMember]< Today(),"Yes",
"No" )
You may have to play around with it a bit, if it doesn't work exactly.
Do not use IF and Switch together. The SWITCH statement is an alternative to a nested IF statement. Each line is considered a condition:
OverdueTeamMember = SWITCH(
TRUE(),
ISBLANK( [DueDateTeamMember] )= TRUE, Blank(),
[Status]="In Progress" && [DueDateTeamMember] < Today(),"Yes",
"No" )
Trust you should be able to get this to work in your file.
@rsbin Hi there, thanks for help. It seems when I test this - it gives me error when there are blanks in the due date.
Do not use IF and Switch together. The SWITCH statement is an alternative to a nested IF statement. Each line is considered a condition:
OverdueTeamMember = SWITCH(
TRUE(),
ISBLANK( [DueDateTeamMember] )= TRUE, Blank(),
[Status]="In Progress" && [DueDateTeamMember] < Today(),"Yes",
"No" )
Trust you should be able to get this to work in your file.
I have come to rely on the Switch Statement in DAX. I find it easier to track multiple conditions.
The following may not be exactly correct, but should get you close.
OverdueTeamMember = SWITCH(
TRUE(),
ISBLANK(DueDateTeamMember)=TRUE, Blank(),
x-Coaching-Sharepoint'[Status]="In Progress" &&
'x-Coaching-Sharepoint'[DueDateTeamMember]< Today(),"Yes",
"No" )
You may have to play around with it a bit, if it doesn't work exactly.
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |