Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 😀
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
109 | |
100 | |
95 | |
38 | |
37 |
User | Count |
---|---|
151 | |
126 | |
75 | |
74 | |
57 |