Forum Discussion

Regular Visitor

3 years ago

Solved

Convert EXCEL formula to DAX

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
3 years ago
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
Anonymous
3 years ago
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.

2 Replies

amitchandak
Super User
3 years ago
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
Anonymous
Not applicable
3 years ago
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.