what is the expression for BRAND_M ?

[admin11]

Hi All

May i know what is the expression to get BRAND_M ?

Paul

[Ashish_Mathur]

Hi,

In the Query Editor, right click on the Sales column and click on "Unpivot other columns".  Remove the Attribute column.  Hope this helps.

[admin11]

@Ashish_Mathur 

Can you take a look for my post below ? As i have been struggle with this question for quite some time and unable to find solution.

https://community.powerbi.com/t5/Desktop/How-to-make-use-of-one-table-to-replace-3-table/td-p/225667...

[admin11]

@Ashish_Mathur 

Thank you for sharing.

I cannot do the merge column at PQ , because below field is not appear at PQ.

BRAND_C =

IF ( 'SALES'[BRAND] = Blank(),

"No Brand",if(SALES[BRAND] in

{"HMS","HAKKO","BECKHOFF","EMERSON","MITSUBISHI","MSA","REDLION","UNIVERSAL","GE","PROJECT","NON ","INTERNAL ","ROBOTIQ"},

'SALES'[BRAND], "Other"))

Using DAX is working fine :- 

BRAND_M = 'SALES'[BRAND_C] & 'SALES'[BRAND_5]

Paul

[ALLUREAN]

Hi @admin11 

You can try with merge columns in Power Query

https://www.dropbox.com/s/9efvupzvxtl5swn/BRAND_M.pbix?dl=0

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

[admin11]

@ALLUREAN 

Thank you for sharing. 

I am unable open your file , as my PBI is older version. 

By the way i try to use PQ for my issue is the 2 column i wanted to merge . one of the column not appear at PQ , due to it is a expression :-

BRAND_C =

IF ( 'SALES'[BRAND] = Blank(),

"No Brand",if(SALES[BRAND] in

{"HMS","HAKKO","BECKHOFF","EMERSON","MITSUBISHI","MSA","REDLION","UNIVERSAL","GE","PROJECT","NON ","INTERNAL ","ROBOTIQ"},

'SALES'[BRAND], "Other"))

Another column is appear at PQ , field name BRAND_5

May i know what is the work around ?

Paul

[ALLUREAN]

If understand properly, this is a calulated column using DAX? In this case you can do the same condition in PQ and then merge both columns?

[admin11]

@ALLUREAN 

You are right BRAND_C is calculate column using DAX.

Since Calculate column not appear in PQ . 

it is possible to make use of DAX code to merge these 2 field ?

Paul

[ALLUREAN · Accepted solution]

You can try with new calculated column:

BRAND_M = 'SALES'[BRAND_C] & 'SALES'[BRAND_5]

[admin11]

@ALLUREAN 

https://community.powerbi.com/t5/Desktop/Error-msg-when-i-try-to-combine-2-column-data-into-1-column...

Pls help me on above post.

Paul

[admin11]

@ALLUREAN 

Thank you very much , it work fine now

[Greg_Deckler]

@admin11 So generally something like MAX('Table'[BRAND_M]) but not entirely clear on what you are looking to achieve. 

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.