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 ,

 

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi camargos88 ,

       

      At the moment I have a direct query to a table in SQL Server. I would like to make this change in Power query without any change to the table in the db.

       

      I have recreated this in the Adventure works and this is the query generated. WHere do you reckon I need to change?

       

      let
          Source = Sql.Database("******", "AdventureWorks2012"),
          HumanResources_Employee = Source{[Schema="HumanResources",Item="Employee"]}[Data],
          #"Removed Columns" = Table.RemoveColumns(HumanResources_Employee,{"Person.Person", "Production.Document", "Purchasing.PurchaseOrderHeader", "Sales.SalesPerson"}),
          #"Sorted Rows" = Table.Sort(#"Removed Columns",{{"BirthDate", Order.Ascending}})
      in
          #"Sorted Rows"

      • camargos88's avatar
        camargos88
        Community Champion
        6 years ago

        Hi Anonymous ,

         

        After select Direct Query, you click on Advanced options and write your custom SQL.