Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Escher Oz]

Hi,

I’m trying to create in Query editor this M: 

Planned Fix Version = if(customfieldvalue[CUSTOMFIELD]=10211, RELATED(‘version'[vname]))

I tried to do it with creating an index column and then with this expression: version[Planned Fix Version]{[Index1]}
but I received an errors

someone have an idea? 

——————————
Escher
——————————

[Ben Howard]

Hi Escher,  Power Query does not use DAX, it uses M.  Importantly M can only reference the current table. 

Can you be more specific about the problem you are trying to solve, it may be achievable in DAX in the Power BI Desktop.  Please be sure to include so images of the model and the relevant data.

——————————
Ben Howard
United Kingdom
——————————
——————————————-

[Escher Oz]

Thank you Ben for your quick response, 
I fixed my mistake.

My data base based on Jira schema, unique ID from one table connected to the data in another table.

in this case the M in above solve the issue, it is bring the data from table ‘version’ to this table based on the coded information in ‘10211’ 
but I want to do the same in Power Query, since I need to group the records to one line and one of the column is “Planned Fix Version”

Escher

——————————
Escher oz.escher@gmail.com
3470105
——————————
——————————————-

[Ben Howard]

Hi Escher, thanks for the update.  I too have worked on Jira with Power BI and feel your pain with the random table structure they seem to employ!  Good luck

——————————
Ben Howard
United Kingdom
——————————
——————————————-

[Escher Oz]

Thank you Ben

Do you have any idea how to solve thus issue?

Escher

——————————
Escher oz.escher@gmail.com
3470105
——————————
——————————————-

[Ben Howard]

I thought you said you fixed it?

——————————
Ben Howard
United Kingdom
——————————
——————————————-

[Escher Oz]

Sorry for miss understanding…

I have a solution with M
I don’t know how to solve it with Power Query since I need to do more manipulation on the data like grouping…
do you have any idea?
Regards,
Escher

——————————
Escher oz.escher@gmail.com
3470105
——————————
——————————————-

[Ben Howard]

I’m sorry, I am still miss understanding…   M is the code you write in Power Query, so if you have a soln in M, you already have the soln in Power Query??

——————————
Ben Howard
United Kingdom
——————————
——————————————-

[Escher Oz]

Sorry if I made some mistakes

the column added from this view 

I wish to add the column from query editor
is it possible? 
 Escher

——————————
Escher oz.escher@gmail.com
3470105
——————————
——————————————-

[Ben Howard]

Hi Escher,

As per my original post, “Importantly M can only reference the current table”.  You could merge the tables together in Power Query and that would give you access to the data, but it might be very expensive in terms of data size and computing power. 

——————————
Ben Howard
United Kingdom
——————————
——————————————-