Forum Discussion
Days between two dates columns in DirectQuery
Hello community, I tried, unsuccesfuly, to subtract two date in DirectQuery but impossible.. How can I do this?
ricgin Given that the operation folds to SQL, it should work just fine in DQ mode.
What errors are you getting if you try this? What's the formula in the formula after the substraction?
when I create a new column (in the query editor) to substract 2 columns, PowerBI Desktop said that : if I want to apply the changes I need to switch to import mode
Me too!
I also get the same error.
