Power BI

From Torben's Wiki
Jump to navigationJump to search

convert datetime column to date of monday that week

In Data View, add column using this formular

my_week_sheet_closed = trunc(d_sheet_view[closure_date] - WEEKDAY(d_sheet_view[closure_date].[Date],2) + 1)