Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
How to write the below condtion in DAX.
case when
(date1 - Date2) > 7
then count distinct (Account Num)
else
0
I have written as below
Count AcctNumber=
Var Acc_cond = (FORMAT ( TODAY (), "YYYY-MM-DD" ) - FORMAT ( "Account"[Start Date], "YYYY-MM-DD" ))
Var CountDist =
CALCULATE(DISTINCTCOUNT('Account'[Account Number]),
Acc_cond > 7 )
RETURN if( Cond1> 7, CountDist, 0)
unalbe to get the data, getting below error
Thanks,
Solved! Go to Solution.
@ramshoney1225 , Try like
Count AcctNumber=
Var Acc_cond = (FORMAT ( TODAY (), "YYYY-MM-DD" ) - FORMAT ( "Account"[Start Date], "YYYY-MM-DD" ))
Var CountDist =
CALCULATE(DISTINCTCOUNT('Account'[Account Number]),Filter(Account, datediff(Account[Start Date],TODAY (),day)+1 >7))
RETURN CountDist
@ramshoney1225 , Try like
Count AcctNumber=
Var Acc_cond = (FORMAT ( TODAY (), "YYYY-MM-DD" ) - FORMAT ( "Account"[Start Date], "YYYY-MM-DD" ))
Var CountDist =
CALCULATE(DISTINCTCOUNT('Account'[Account Number]),Filter(Account, datediff(Account[Start Date],TODAY (),day)+1 >7))
RETURN CountDist
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |