Forum Discussion
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]]...
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
Hi sb2848
Please try these two measures formulas .
Measure 1 = DATEVALUE(SELECTEDVALUE('Table'[Date]))Measure 2 = DATEVALUE(SELECTEDVALUE('Table'[Date]))-WEEKDAY('Table'[Date])+1Best 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.
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.