Hi all, I have the below data table. I require 2 columns to be added:Week EndingWeeks denoted by ending on the Sunday for previous weeki.e. Week Ending 12/04 is for the week 06/04/20 - 12/04/20Is it possible to have the Field Value of this column to be "Week No. 1 - WE 12/04"QuarterFirst week of Quarter is the Week Ending 12/04/20 Date Table: Calendar = ADDCOLUMNS(CALENDAR(DATE(YEAR(MINX('Export Placements','Export Placements'[PlacementStartDate])),1,1),DATE(YEAR(MAXX('Export Placements','Export Placements'[PlacementDate])),12,31)),"YEar",YEAR([Date]),"WeekNum",YEAR([Date])&"-"& FORMAT(WEEKNUM([Date]),"00"))

Hi HenryJS ,Can I know which formula used in calculated column "Calendar'[WeekDay]"? It should be just like below one:Calendar'[WeekDay]=WEEKDAY(Calendar[Date],2)Best RegardsRena

HenryJS

Post Prodigy

6 years ago

Solved

Data Table: Weekend Ending Column

Hi all,

I have the below data table. I require 2 columns to be added:

Week Ending
- Weeks denoted by ending on the Sunday for previous week
- i.e. Week Ending 12/04 is for the week 06/04/20 - 12/04/20
- Is it possible to have the Field Value of this column to be "Week No. 1 - WE 12/04"
Quarter
- First week of Quarter is the Week Ending 12/04/20

Date Table:

Calendar = ADDCOLUMNS(CALENDAR(DATE(YEAR(MINX('Export Placements','Export Placements'[PlacementStartDate])),1,1),DATE(YEAR(MAXX('Export Placements','Export Placements'[PlacementDate])),12,31)

),"YEar",YEAR([Date]),"WeekNum",YEAR([Date])&"-"& FORMAT(WEEKNUM([Date]),"00"))

Anonymous
6 years ago
Hi HenryJS ,
Can I know which formula used in calculated column "Calendar'[WeekDay]"? It should be just like below one:
Calendar'[WeekDay]=WEEKDAY(Calendar[Date],2)
Best Regards
Rena