Transforming a date related Excel formula into DAX

[MXSven]

Hi Everybody,

I am struggeling with the translation of an Excel formula "StartDate" into Power BI (DAX)

StartDate = "="&(Today()-DATE(1970;1;1))*60*60*24,
EndDate = "=1646092800"

It appears to me that the "date" & "today" formula concept of excel, which returns an according serial number

doesn't exist in PowerBi

[Anonymous]

StartDate = (Today()-DATE(1970,1,1))*60*60*24

[MXSven]

I put it exactly like this,
but today and date couldn't be recognized

[Anonymous]

In Power BI, create a new measure

StartDate = (Today()-DATE(1970,1,1))*60*60*24

[MXSven]

Thanks for your fast reply

but how do get the measure then into:

[Anonymous · Accepted solution]

Ohhhh..

I know, in Power Query , you should use m language, not dax

StartDate = "=" & Text.From(Duration.TotalSeconds(DateTime.From(Date.From(DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), 0))) - #datetime(1970, 1, 1, 0, 0, 0)))

change the 0 to your timezone

DateTimeZone.SwitchZone - PowerQuery M | Microsoft Docs

[MXSven]

sorry I didn't know that

your solution works perfect

I wouldn't have been able to solve this on my own with Query M.

Thanks

[Anonymous]

TODAY function (DAX) - DAX | Microsoft Docs

DATE function (DAX) - DAX | Microsoft Docs

[MXSven]

Thanks,
but I don't got it to work

StartDate = "="&((Date(2022,6,10)-DATE(1970,1,1))*60*60*24)

doesn't recognize Date/DATE

Any hints