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.

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.