Convert EXCEL formula to DAX

[sb2848]

Hi,

I am migrating excel reports to Power BI. I need help converting the Excel formulas below to DAX.

=DATEVALUE(TEXT([@[ClosedCaseDate]],"m/yyyy"))

=DATEVALUE(TEXT([@[ClosedCaseDate]],"m/d/yyyy"))-WEEKDAY([@[ClosedCaseDate]])+1

[amitchandak · Accepted solution]

@sb2848 , You have date values function power query too

New date = DATEVALUE([Text Date column])

Week start date, assuming you already have date

Week start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1 

[v-yetao1-msft · Accepted solution]

Hi @sb2848 

Please try these two measures formulas .

Measure 1 = DATEVALUE(SELECTEDVALUE('Table'[Date]))

Measure 2 = DATEVALUE(SELECTEDVALUE('Table'[Date]))-WEEKDAY('Table'[Date])+1

 Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@sb2848 , You have date values function power query too

New date = DATEVALUE([Text Date column])

Week start date, assuming you already have date

Week start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1