Forum Discussion

PBIfanatic's avatar
PBIfanatic
Helper V
6 years ago

Difference between dates - power query

Hi,   How do I calculate the difference between the dates in power query without loosing query folding? I tried using Duration.Days function, but it comes with an error saying I need to import the...
Need Help
PBIfanatic's avatar
PBIfanatic
Helper V
6 years ago

Hi Anonymous ,

 

No, it isnt unfortunately. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi PBIfanatic ,

You can use the function DATEDIFF in DAX to create one calculated column instead of calculating the difference between dates in Power Query:

Best Regards

Rena