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,
I'm trying to create a new field via a new formula in which I use the WHERE function.
I want to calculate the number of hours WHERE value is higher then zero (o)
Unfortunately an error shows...
Solved! Go to Solution.
Hi @JeffreyBl ,
You can use it like shown below
Billable uren = CALCULATE(SUM('DEA-Amsterdam'[Totale uren] ), 'DEA-Amsterdam'[Omzetwaarde] > 0)
Regards,
Column = Calculate(sum([Totale uren] ),'DEA-Amsterdam'[Omzetwaarde] > 0)
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Hi @JeffreyBl ,
You can use it like shown below
Billable uren = CALCULATE(SUM('DEA-Amsterdam'[Totale uren] ), 'DEA-Amsterdam'[Omzetwaarde] > 0)
Regards,
Hello @JeffreyBl
This should work _
Billable uren = CALCULATE('DEA-Amsterdam'[Totale uren],'DEA-Amsterdam'[Omzetwaarde] > 0')
User | Count |
---|---|
76 | |
74 | |
61 | |
61 | |
45 |
User | Count |
---|---|
108 | |
103 | |
93 | |
83 | |
64 |