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
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

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.