Forum Discussion

PowerBIBeginer's avatar
PowerBIBeginer
Helper V
2 years ago

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...
Need Help
PowerBIBeginer's avatar
PowerBIBeginer
Helper V
2 years ago

Thank You for your reply and time share on my query.

Customer NameLoBTypecomments
Piramal IndHealthPrimary 
Piramal IndHealthExcessCopy this row and paste in different table and should get delete from this current tabel
NikeSportsExcess 
TataTransportPrimary 
TataFoodExcessCopy this row and paste in different table and should get delete from this current tabel
TataFoodPrimary 
Piramal IndFoodExcess 
SkyBagLifestylePrimary 
SkyBagLifestyleExcessCopy this row and paste in different table and should get delete from this current tabel
SkyBagEntertainmentNLP 
SkyBagEntertainmentExcess 

 

Output will look like..

Current table-

Customer NameLoBType
Piramal IndHealthPrimary
NikeSportsExcess
TataTransportPrimary
TataFoodPrimary
Piramal IndFoodExcess
SkyBagLifestylePrimary
SkyBagEntertainmentNLP
SkyBagEntertainmentExcess

 

and another table wil add those deleted rows

Customer NameLoBType
Piramal IndHealthExcess
TataFoodExcess
SkyBagLifestyleExcess
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

 

  • PowerBIBeginer's avatar
    PowerBIBeginer
    Helper V
    2 years ago

    Thank You so much! Very exceited looking at your reply and highly appriciate your time and responce. I highly appriciate You and all the Fabric Community. Sir, I will check this solution and will revert you.

  • PowerBIBeginer's avatar
    PowerBIBeginer
    Helper V
    2 years ago

    Hi, one query please.. How do I add this dax in "Transform Data - applied steps"? I'm basically working there on eliminating steps. Do I need to create this in "Advance editor" under the steps the advaance editor? Pls suggest

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      You don't. DAX code is used in the User interface phase. Transform steps are written in Power Query, in the data acquisition and transformation stage. Those are separate processes.

  • PowerBIBeginer's avatar
    PowerBIBeginer
    Helper V
    2 years ago

    Hi, the post where you share screenshot in that we can clearly see that separation happen correctly. But it dosent work on my table..😔 the logic which I said, if same account and LOB and contains Primary and Excess types, then remove excess to the other table, that is not happening.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi PowerBIBeginer ,

       

      So what results are you getting now and are there any other relationships, please provide more information.

       

      Best regards,
      Community Support Team_ Scott Chang