topic Re: Convert EXCEL formula to DAX in DAX Commands and Tips

Convert EXCEL formula to DAX

sb2848 — Fri, 30 Sep 2022 14:29:44 GMT

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

Re: Convert EXCEL formula to DAX

amitchandak — Sat, 01 Oct 2022 02:26:45 GMT

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

Re: Convert EXCEL formula to DAX

Anonymous — Thu, 06 Oct 2022 09:34:40 GMT

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.