Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Shift next column data one step back with condition

Hi All,

 

I have one situaltion where I am merging two spreadsheets from single file in which there are separate column for each week start date and end date, the problem is for March 2021 there are 5 weeks and April 2021 has only 4 weeks, which is causing the issue.

 

So, where there is a month with extra week say 5th week, I see the data like this. 

In this I wanted adjust the counts for Full month March Aligned on to the Full Month April column.

How can we do this? 

I will appreciate any help.

 

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , if they came as two table in power bi, you can rename columns before merge , so that they merge under correct name

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      amitchandak 

      I have 7 spreadsheets in the file which I am expanding them from the data node.

       

      So, here I am expanding and it creates one table to stored all the sheets, is there any way I can just remove the weeks1- week5 columns before I get this merged data?

       

      Say, March sheet has week1- week5 I dynamically delete that 

      And if any month sheets has week1-week4 it gets dynamically deleted before it is merging?