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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks camargos88 .

 

I was thinking if there are other ways of using Power BI functionalities to calculate this. 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

Whether the problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help other members in the community find the solution easily if they face the similar problem with you. Thank you.

Best Regards

Rena

  • 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