How to group date using a week End Date column ?

[Anonymous]

Hi Community,

I have a column that is Date data type . I want to create Start Date and End Date using the same Column . Here , I want Start Date and End date to be Previous Week Monday and Current Week Monday . 

I created 2 Calculated columns  as shown below  . 

Week Start Date = SSPR[ActivityDateTime] - WEEKDAY( SSPR[ActivityDateTime],2 ) + 1

Week End Date = SSPR[ActivityDateTime] + 8 - WEEKDAY( SSPR[ActivityDateTime],2 )

I am getting the dates properly as shown below in screen shot. 

Now, i want to group data by Week End Date and do a count of rows to show them in Stacked column chart  . When i do that , I am getting a visual like shown below. The dates in X-Axis are not coming correctly . They are showing dates of Sundays of every week. But I want to show the Mondays which is Week End date of every week . 

Kindly help . 

G Venkatesh 

[V-pazhen-msft · Accepted solution]

@Anonymous 
The group bin feature for data column will group based on the whole date. Try change the date type to Text, create groups with the text date in the x-axis.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , are you using weekend date column on the x-axis. I doubt that. Because date is not same.

Also, make sure the axis is categorical

[Anonymous]

Hi Amit,

Yes I have created group(bins) based on Weekend Date as Direct Column of Weekend Date is not grouping data . When I add the new column based of Grouped bins Weekend date, thats where dates appeared differently. 

Yes I have turned the Axis type from Continous to Categorical. 

Thanks,

G Venkatesh