Forum Discussion
Calculate days between date columns
? where are you creating your measure/column?
it should look somehow like this where you enter it
it should recognize the function
you can also use iferror but its a bit forced sometimes and not always the most beautiful solution but having something working quick is most important sometimes
aprice7 you need to do that in dax not power query so close and load out of power query and do it in the front end of the model
Resolver IV? where are you creating your measure/column?
it should look somehow like this where you enter it
it should recognize the function
you can also use iferror but its a bit forced sometimes and not always the most beautiful solution but having something working quick is most important sometimes
I am in Query Editor > Add Column > Custom Column. That is where I've been trying all the formulas I have seen on the blog related to this, but receiving the error I mentioned above.
- vanessafvg
Community Champion
aprice7 you need to do that in dax not power query so close and load out of power query and do it in the front end of the model