Forum Discussion
Solved
OR feature triggered by key
Hey community, I'm trying to build a measure for which I don't know if I need it to be in Power Query, Calculated Column or measure. On a similar table, this is what I'm trying to do This...
Yahya
Add this as a new column in Data Model:Swap_Key = VAR _Adv = CALCULATE( COUNTROWS('Table (4)'), 'Table (4)'[Value]="SWAP") RETURN IF(_Adv>0,"SWAP",BLANK())If you are satisfied with my answer, please mark it as a solution so others can easily find it.
Don't forget to give KUDOS ? to replies that help answer your questions
Subscribe to ExcelFort: Learn Power BI, Power Query and Excel
Yahya
Add this as a new column in Data Model:
Swap_Key =
VAR _Adv = CALCULATE(
COUNTROWS('Table (4)'),
'Table (4)'[Value]="SWAP")
RETURN
IF(_Adv>0,"SWAP",BLANK())
If you are satisfied with my answer, please mark it as a solution so others can easily find it.
Don't forget to give KUDOS ? to replies that help answer your questions
Subscribe to ExcelFort: Learn Power BI, Power Query and Excel
Hey Fowmy,
Thank you for your reply. This seems to work as expected š