Forum Discussion

HenryJS's avatar
HenryJS
Icon for Post Prodigy rankPost 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/...
data protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    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

HenryJS's avatar
HenryJS
Icon for Post Prodigy rankPost Prodigy
6 years ago

Hi Greg_Deckler I need this for Columns in a Matrix. 

 

It won't let me drag the mWeekEnding measure to columns for the matrix