Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am subtrating two date column which is calculated but getting output as summed don't know why . Below is one example of that right one is good as it is 197 it calualyed in M query . left one is calculted in power bi desktop calulated column .
Solved! Go to Solution.
Hi @navneet0512
Try this DAX for calculated column :
Hi @navneet0512
Try this DAX for calculated column :
want to subtract order recieved date from actual ship date means [actual shipdate - order recieved date]
Hi @navneet0512 you can replace the order of the parameters of the formula.
Just note that in your example start day is after the end day ...so the result will be (-197)
User | Count |
---|---|
114 | |
107 | |
103 | |
57 | |
36 |
User | Count |
---|---|
149 | |
136 | |
101 | |
91 | |
62 |