Power BI
Revision as of 11:54, 6 February 2023 by Torben (talk | contribs) (→CSV/TSV parse column names from row1)
create date table
MyDateTable = CALENDAR(2022-07-01,TODAY()) or MyDateTable = CALENDAR(MINX('myTable', 'myTable'[created (day)]),TODAY())
add column of first day of week
MyWeekStart = trunc(MyDateTable[MyDate] - WEEKDAY(MyDateTable[MyDate],2) + 1)
convert datetime column to date of monday that week
In Data View, add column using this formular
MyWeekStart = trunc(MyDateTable[MyDate] - WEEKDAY(MyDateTable[MyDate],2) + 1) or my_week_sheet_closed = trunc(d_sheet_view[closure_date] - WEEKDAY(d_sheet_view[closure_date].[Date],2) + 1)
CSV/TSV parse column names from row1
= Table.PromoteHeaders(Source, [PromoteAllScalars=true])