Duplicate Week Due to overlap date between months

[RL79]

Hi All

Wondering if someone can help with my date table
I am getting a week overlap during months 1 and 2 due to 1 day of the week being in January and the other days being in Feb
What is the solution to fix this 

[Anonymous · Accepted solution]

Hi @RL79 

So what effect are you trying to achieve? Hide the duplicate data for January? If yes, you can refer to my method below .

Choose the Matrix ,and turn off Word wrap in the visual , then hide the columns you don't need .

I have attached my pbix file , you can refer to it .

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.