Forum Discussion
Solved
Calculate days between date columns
I've read a lot of question/answers on the forum about this topic and cannot get any of the solutions to work. I have a date column where I need to determine if the dates are past due from today'...
? 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
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
Community Championaprice7 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