Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Bill comparison

I have an Excel spreadsheet where I download my companies phone bill and paste the data each month. The data starts with the phone number in column A, followed by the type of line (e.g. Broadband, Te...
Need Help
Tips and Tricks
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    You can create new calculated table Table_UNION to union the three month table data, then create measure Filter1 in Table_UNION ,put the Filter1 into the Visual Level Filter of table visual which will display the result ,setting Filter1 as "is not blank".

     

    Table_UNION= UNION(ADDCOLUMNS('January table',"Month","January"),ADDCOLUMNS('February table',"Month","February"),ADDCOLUMNS('March table',"Month","March"))

     

    Filter1= IF(SUM(Table_UNION[CALL VOLUME])=BLANK(),1,BLANK())

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Amy,

 

Thanks for your reply.

This is the kind of spreadsheet i'm working with. It's got three tabs as an example - one for March, one for February and one for January. 

On this one, the phone numbers (column A which is called Service no) are the same on each tab but not on the same row.

Unfortunately my organisation has blocked sharing OneDrive docs to external users, but here are some screenshots. If an email copy is easier, pm me an email address to send it to and I can do that.

Thanks so much for your help :)

tex628's avatar
tex628
Community Champion
7 years ago

How do you want the result visualized? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    My end goal is to be able to see which numbers have 0 in call volume for 3 months. So i'm open to anything that'll give me that really. 

    Thank you

    • tex628's avatar
      tex628
      Community Champion
      7 years ago

      Does each page in the excel equal the total volume for that month?

    • v-xicai's avatar
      v-xicai
      Community Support
      7 years ago

      Hi Anonymous ,

       

      You can create new calculated table Table_UNION to union the three month table data, then create measure Filter1 in Table_UNION ,put the Filter1 into the Visual Level Filter of table visual which will display the result ,setting Filter1 as "is not blank".

       

      Table_UNION= UNION(ADDCOLUMNS('January table',"Month","January"),ADDCOLUMNS('February table',"Month","February"),ADDCOLUMNS('March table',"Month","March"))

       

      Filter1= IF(SUM(Table_UNION[CALL VOLUME])=BLANK(),1,BLANK())

       

       

       

       

       

       

       

       

       

      Best Regards,

      Amy

       

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