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 |
---|---|
100 | |
88 | |
79 | |
75 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |