To create a structured table with Power Query

[Yanou]

Good evening to all,

I would like to know how to create a structured table with Power Query. I mean when I take my data base or a data range, I would like to transform it into a structured table and choose a name for it. 

Thanks you

[v-cgao-msft · Accepted solution]

Hi @Yanou ,

Would you share some sample data? Please see if these help:

Solved: Changings to data structure in Power Query - Microsoft Power BI Community

Solved: structure table - Microsoft Power BI Community

Solved: Transform Table Structure - Microsoft Power BI Community

How to unpivot twice

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[v-cgao-msft · Accepted solution]

Hi @Yanou ,

Would you share some sample data? Please see if these help:

Solved: Changings to data structure in Power Query - Microsoft Power BI Community

Solved: structure table - Microsoft Power BI Community

Solved: Transform Table Structure - Microsoft Power BI Community

How to unpivot twice

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Yanou]

Hello V-CGAO,

Thanks for your answer. There is a link to better explain my issue : 

https://we.tl/t-u7egi15kjO 

Thanks for your help.

[v-cgao-msft · Accepted solution]

Hi @Yanou ,

Still a little confused.🤔 Please try creating two parameters and then go to the filter table and see if that works for you.

Parameters - Power Query

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data