Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all
I am trying to workout if something is within timeline, but i need it to check if a field has a date first then if so work out X if not check this field isnt blank and work out Y
this is the Dax i am working with, i manage to get it to do one half but then it doesnt seem to do the second field blank check:
Solved! Go to Solution.
@EloiseJane Try out with Switch:
Test PPA =SWITCH(TRUE(),
DATEDECISS>DATE8WEEK,"Exceeds",
DATEDECISS=BLANK(),BLANK(),
DATEDECISS>DATE8WEEK,"Exceeds", "Within")
@EloiseJane Try out with Switch:
Test PPA =SWITCH(TRUE(),
DATEDECISS>DATE8WEEK,"Exceeds",
DATEDECISS=BLANK(),BLANK(),
DATEDECISS>DATE8WEEK,"Exceeds", "Within")
thank you this worked 😀
User | Count |
---|---|
102 | |
84 | |
77 | |
70 | |
67 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |