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.
Hi, how do we convert COUNTIFS(Table1[@[ESCAL_TO1]:[ESCAL_TO3_DT]],">0") excel formula to power bi.
Hi the answer could be as below but problem is in our case escal to1 is text not date
Sorry, i do not understand what you want. please describe it better
Proud to be a Super User!
Hi, we have an excel formula COUNTIFS(Table1[@[ESCAL_TO1]:[ESCAL_TO3_DT]],">0") we need to convert to power bi formula. how shall we do it.
and in this case ESCAL_TO1 data type will be text and data will be in text where as ESCAL_TO3_DT will have date as datatype.
So how do we convert the above formula in power bi.
I do not really understand the idea behind your count? Can you please say the desired result for your example or make a good example with the underlaying data and you result 🙂 Thank you
Proud to be a Super User!
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |