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

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.

    • 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