SQL query to Dax

[Anonymous]

I have a sql query that uses the following formula:

Datepart(Datetime()) -  Datepart(table.column_name) as Date_age

what would be the equivalent of this in Power Query?

[SivaMani · Accepted solution]

@Anonymous ,

Power Query -  https://learn.microsoft.com/en-us/powerquery-m/duration-days
DAX - https://learn.microsoft.com/en-us/dax/datediff-function-dax

[SivaMani]

@Anonymous ,

Power Query -  https://learn.microsoft.com/en-us/powerquery-m/duration-days
DAX - https://learn.microsoft.com/en-us/dax/datediff-function-dax