Forum Discussion
Logic / Dax require
Hi All, Query which I'm asking I'm not sure whether its possible in power bi or not. Let me narrate the exact condition. Col A - Customer name Col B - Line of Business (could be anything) C...
Thank You for your reply and time share on my query.
| Customer Name | LoB | Type | comments |
| Piramal Ind | Health | Primary | |
| Piramal Ind | Health | Excess | Copy this row and paste in different table and should get delete from this current tabel |
| Nike | Sports | Excess | |
| Tata | Transport | Primary | |
| Tata | Food | Excess | Copy this row and paste in different table and should get delete from this current tabel |
| Tata | Food | Primary | |
| Piramal Ind | Food | Excess | |
| SkyBag | Lifestyle | Primary | |
| SkyBag | Lifestyle | Excess | Copy this row and paste in different table and should get delete from this current tabel |
| SkyBag | Entertainment | NLP | |
| SkyBag | Entertainment | Excess |
Output will look like..
Current table-
| Customer Name | LoB | Type |
| Piramal Ind | Health | Primary |
| Nike | Sports | Excess |
| Tata | Transport | Primary |
| Tata | Food | Primary |
| Piramal Ind | Food | Excess |
| SkyBag | Lifestyle | Primary |
| SkyBag | Entertainment | NLP |
| SkyBag | Entertainment | Excess |
and another table wil add those deleted rows
| Customer Name | LoB | Type |
| Piramal Ind | Health | Excess |
| Tata | Food | Excess |
| SkyBag | Lifestyle | Excess |
Hi PowerBIBeginer ,
I made simple samples and you can check the results below:
Measure = var _t = ADDCOLUMNS('Table',"Same",COUNTAX(FILTER(ALL('Table'),[Type]<>"NLP"&&[Customer Name]=EARLIER([Customer Name])&&[LoB]=EARLIER([LoB])),[Type]))
var _t2 = IF(MAX('Table'[Type])="Excess",1,0)
RETURN IF(MAXX(_t,[Same])<>1&&_t2=1,1,0)
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.