Forum Discussion
Datediff Problem With Direct Query
Hey guys! I have a problem with the DATEDIFF formula in Power Bi. I need to perform a DATEDIFF between two dates, which are in a fact table with more than 17 million rows. The difference number be...
Only in DAX. I know that it works in Power Query, however, in this project, we only have Direct Query and it is unfeasible to use Power Query, as well as, we cannot solve it in the bank.
The fact is, it's basic arithmetic, which could be easily solved in ETL, Banco or Power Query. But the case specifies the resolution via DAX, as it is in Direct Query.
And the difficulty lies exclusively in DATEDIFF transforming thousands of lines in days, communicating with the Bank in DQ.
And if you use a direct dax like dae1 - date2, without datediff function.
I tried too, it didn't work. I also tried to transform it into an integer, but it doesn't work via DQ. :s