Converting value to a date

[Anonymous]

Hi there,

In Excel I have A1 = 10/03/2019 and B1 I did =Value(A1) and I got 43741 as a number

Also In A2 = 43741 and I format it to a date and I got 10/03/2019

Is there any way to do it in DAX? conver number to a date and date to a value.

I'm also looking for converting week number to last SAT date of that week like week 40 = 10/05/2019

Thanks,

Oded Dror 

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

I think it is better to create a date table. Then create some columns you want(number,weeknum...). You can convert numbers to the correct date against the date table by this way.

[Anonymous]

Well, I think it's technically possible but that does not mean you should do it. Why you want do it?

Regarding finding the next saturday, it depends on your model, but if you have a Date dimension (called DimDate) with a "date" column, i would add a custom column with the formula

NextSat=DateDim[date]+
  -- this will return 1 if Sunday to 7 if saturday. So if it's already saturday add 0, otherwise add difference
   7-WEEKDAY(DateDim[date],1)