Compare quick mesurement with a cell value from another table

[Anonymous]

Hello,

I receive an excel file that contain a summary sheet and somme other sheet.

The summary sheet contains sum of values calculated in other sheets.

ex:

sheet 1 name mesure	value
sheet 2 name mesure	value
sheet 3 name mesure	value

My others sheets have differents structures.

I've imported my excel file into power bi and turned each sheet in a table

I've done my quick mesurements in all sheets and I want to add a column into the summary sheet to report each quick mesurement in front of the value column.

The purpose is to verify that each quick mesurement matches corresponding cell value.

Is it possible ?

Any suggestion?

If it seems unclear, let me know. I'll try to re explain myself

[Mariusz · Accepted solution]

Hi @Anonymous 

Yes, you can add a column to your summary sheet with a SWITCH function like.

Column = 
SWITCH( 
    'Table'[MeasureName],
    "sheet 1 name mesure", [DAX Measure 1],
    "sheet 2 name mesure", [DAX Measure 2],
    "sheet 3 name mesure", [DAX Measure 3]
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn