Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
86 | |
68 | |
64 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |