Power Query M formula language or Formula in Power Query

[roykana]

Dear All Master ,

Please help me so that I do not use excel formulas such as in columns C, D, E, F that I marked yellow and I have a custom column in the power query namely PQ-ITEM NO NEW, PQ-GROUP SUPPLIER FIX, PQ-YEAR, PQ -DESCRIPTION so I want the results to use the power query formula or M language so that the results are the same as columns C, D, E, F I have yellow marking.
The reason I did not use the excel formula is because the record is 200000 lines so when it is refreshed it makes the formula calculation so that it makes it very long. For sheet master items do not need to be unpivoted so that they make many rows.
Please give me the solution.
My link file : FORMULA IN POWER QUERY.xlsx
Thanks You

Kana

 

[roykana]

Add a conditional column (Power Query) - Microsoft Support

With Power Query, you can add a conditional column to your query. You can define IF-THEN-ELSE conditions in your query. When the conditions are fulfilled, the conditional column will automatically display the values that you specified.

support.office.com

Merge queries (Power Query) - Microsoft Support

A merge query creates a new query from two existing queries. One query result contains all columns from a primary table, with one column serving as a single column containing a navigation link to a related table.

support.office.com

I used excel 2010 not excel 2016

 

[sandy666]

Power Query aka Get&Transform
post#6 5th link
doesn't matter version of Excel, should be 2010 or above

btw. how do you want use Power Query without Power Query?

 

[roykana]

Power Query aka Get&Transform
post#6 5th link
doesn't matter version of Excel, should be 2010 or above

btw. how do you want use Power Query without Power Query?

I have used a power query in Excel 2010. You can see my excel file

 

[roykana]

I am waiting for someone else to help me

 

[sandy666]

see this s666-PQ-FORMULA IN POWER QUERY.xlsx

 

[roykana]

see this s666-PQ-FORMULA IN POWER QUERY.xlsx

can i download the excel file that you sent ?

 

[sandy666]

sure, you can
it's yours

 

[roykana]

sure, you can
it's yours

I can't download the file

 

[sandy666]

did you open it in Excel Online?
then File - Save as

 

[roykana]

now I can download the file