Do you feel that you are Tableau Expert? Then try this challenge 22

Hello All…

Here I am coming with new challenge.

For this challenge data looks like below. Only one column which shows dates. You can prepare data by yourselves and try this challenge.

I have data like this, Date starting from Oct 1^st, 2017 to Sep 30^th, 2018.

Here the challenge showing week of the month. My week starts from 1^st Sunday of month. See below image.

If you see above image, I am showing week of the month column in this report.

As I told earlier, week of the month will start from 1^st Sunday of month. For example, in 2017 Oct 1^st starting from Sunday so Oct 1^st to Oct 7^th is week 1 and so on. Coming to November first Sunday starting from 5^th so week 1 from 5^th Nov to 11^th Nov. Dates before 5^th Nov will be week 5 of previous month.

So, try to write logic to display week of the month.

For more challenges: Click Here

 Experiment… Observe… Learn…