Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Guys, I have a problem, I can't convert this select to PB's DAX, could someone help me?
>>SELECT count(*) as open_open FROM [BASE].[dbo].[Fact_Call] to where a.DateOpen <= '2022-10-31' and (a.StatusCalledID not in (4, 12) or (a.StatusCalledID in (4, 12) and a.DateClosing > '2022-10-31'))<<
Solved! Go to Solution.
Hello @aservan !
I think you want something like this:
open_open =
CALCULATE(COUNT([insert column]), OR(a.DateOpen <= DATE(2022,10,31) && NOT(a.StatusCalledID IN {4,12}), a.StatusCalledID IN {4,12} && a.DateClosing > DATE(2022,10,31)))
Hello @aservan !
I think you want something like this:
open_open =
CALCULATE(COUNT([insert column]), OR(a.DateOpen <= DATE(2022,10,31) && NOT(a.StatusCalledID IN {4,12}), a.StatusCalledID IN {4,12} && a.DateClosing > DATE(2022,10,31)))
TKS MANNNN!
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |