Forum Discussion
Help to define Dax Formula
Hello,
I'm pretty new to using Dax in PowerBI,
I would like to calculate the remaining production qty by calculating (SUM order qty (table 1)) - (SUM production output(table 2)).
rules if the result <0, will be stored as "0" avoid minus.
What Dax formula do I need to use?
Thank you
Anonymous
measure =
var s = sum(table_1[order qty_col_name]) - sum(table_2[production_output_col_name])
return
switch(
true(),
s < 0 , 0 , s)
let me know if this works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠Anonymous
you wrote var.s(
modify it to : var S =
4 Replies
Anonymous
measure =
var s = sum(table_1[order qty_col_name]) - sum(table_2[production_output_col_name])
return
switch(
true(),
s < 0 , 0 , s)
let me know if this works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠Hi Daniel29195 , I still got error like this
Anonymous
you wrote var.s(
modify it to : var S =