March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 😀
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
96 | |
82 | |
69 | |
61 |
User | Count |
---|---|
138 | |
115 | |
115 | |
99 | |
98 |