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
camargos88's avatar
camargos88
Community Champion
6 years ago

Hi PBIfanatic ,

 

Are you using database ? If yes, why don't you create a calculated field on your query ?

 

Ricardo

PBIfanatic's avatar
PBIfanatic
Helper V
6 years ago

Hi camargos88 ,

 

Thanks for your reply, do you mean creating a column in the database?

The problem is, its a long process to make a change to the db.  Hoping Power BI to come to the rescue 🙂

 

 

  • camargos88's avatar
    camargos88
    Community Champion
    6 years ago

    Hi PBIfanatic ,

     

    Can you just submit a query instead of change view/procedure ?

     

    Ricardo

    • PBIfanatic's avatar
      PBIfanatic
      Helper V
      6 years ago

      Hi camargos88 ,

       

      Sorry, do you mean a custom sql?

      • camargos88's avatar
        camargos88
        Community Champion
        6 years ago

        PBIfanatic ,

         

        Yes, I don't know what you are using (view/procedure...) but is it possible to use a hardcode ?

         

        Ricardo