Forum Discussion
Bill comparison
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.
Community SupportHi Anonymous ,
You can try to create measure like DAX below. Or could you please share your sample data or screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.
Measure1 =CALCULATE(LOOKUPVALUE(Table1[phone number],Table1[call volume],BLANK()),DATEADD(TODAY(),-3,MONTH) <=MAX('DateDim'[Date])&&TODAY()>=MIN('DateDim'[Date]))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 :)
