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.

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

Hi  Anonymous ,

 

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case.

 

Best regards

Amy Cai