Turning a number into day/month/year

[brcnyc]

Hi all, I have a question. I have a number column in my data. I want to see these numbers as day/month/year. For example, 400 should be shown as 1 year 1 month 4 days. I could do this in excel with edated formula. Is it possible to do it in power bi?

[amitchandak]

@brcnyc , This will give you time from 1900

Measure = date(0,0,400)
or
column = date(0,0,400)

or

Measure = date(0,0,[other measure])
or
column = date(0,0,[other column])

if you want from any date try like

date(2020,1,1) +date(0,0,400)

You can have some thing like this , you can also concat these like text in one formual
year = quotient([Number],356)
month =quotient(mod([Number],356),30)
month =mod(mod([Number],356),30)