Forum Discussion
tex628
9 years agoCommunity Champion
Assistance needed
Hi! I'm having some issues with something im trying to create. I need to identify the German (DE) ID's where the price doesn't match the Swedish (SE) price for the same ID. The Nor...
- 9 years ago
Hi tex628,
Based on my test, you should be able to use the formula below to create a calculate column in your table to identify the German (DE) ID's where the price doesn't match the Swedish (SE) price for the same ID .
Tag = VAR sePrice = CALCULATE ( FIRSTNONBLANK ( Table1[Price $], 1 ), FILTER ( ALL ( Table1 ), Table1[ID] = EARLIER ( Table1[ID] ) && Table1[Origin] = "SE" ) ) RETURN IF ( Table1[Origin] = "DE" && Table1[Price $] <> sePrice, 1, 0 )Then you can use the tag column as visual level filter or as Slicer to show the result on the report.
Here is the sample pbix file for your reference. :smileyhappy:
Regards
Back2Basics
9 years agoResolver I
I'm not sure this needs Power BI. Can't you just do this manually? it's a very small dataset
tex628
9 years agoCommunity Champion
I'm not able to use the accual dataset here. The one im working with contains over 50 000 rows. Sorry that I have to use a stand-in!