cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
josegdiazv
Regular Visitor

Create Conditional column with large number of conditions.

Dear Community,

I am looking for a way to create a conditional column with Power Query editor but with a large number of conditions, it will be around 325.

 

josegdiazv_0-1616447529275.png

 

I saw also that you can edit the code but it seems also not to be so feasible,

 

Any recommendation to make this task in an easy way?

 

Thank you,

 

Jose G Diaz

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
EricRegnier
Super User
Super User

Unfortunately these are the two methods to apply the transformations that I know of. Not sure what else your specifically looking for, but if you an an idea suggest to submit it here: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

Cheers

View solution in original post

4 REPLIES 4
EricRegnier
Super User
Super User

Hi @josegdiazv,

Where are you trying to use Power Query, in Excel, Power BI or Dataflows? You can always click on "Advanced Editor" in the ribbon and modify the query manually:

EricRegnier_0-1616485157609.png

Hope this helps...

 

josegdiazv
Regular Visitor

Thank you Eric,

 

Yes, I checked the option of the advance editor and do it with the code, but still, I think not a fast way to do it.

 

Any other suggestions?

 

Thank you,

 

Jose G Diaz

EricRegnier
Super User
Super User

Unfortunately these are the two methods to apply the transformations that I know of. Not sure what else your specifically looking for, but if you an an idea suggest to submit it here: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

Cheers

josegdiazv
Regular Visitor

Thank you a lot Eric

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (1,814)