Forum Discussion

RL79's avatar
RL79
Regular Visitor
4 years ago
Solved

Duplicate Week Due to overlap date between months

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 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.