Forum Discussion

RF9809zpf's avatar
RF9809zpf
New Member
3 years ago
Solved

crear nueva tabla

Hola comunidad:   Necesito de su ayuda. Tengo dos tablas, una con datos llamada "ACTUAL" y otra con datos llamado "PRESUPUESTO". En ambas tablas tengo columnas de meses, cuentaS y montos. Tambien h...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi RF9809zpf ,

     

    To create a table that contains the data for the entire year, you can use Power Query to filter the data from the "CURRENT" table for the months from January to the selected month, and filter the data from the "BUDGET" table for the months from the selected month to December.

    To filter the data from the "CURRENT" table, you can use the "Filter Rows" transformation to keep only the rows where the "version" column contains the text "Current". To filter the data from the "BUDGET" table, you can use the "Filter Rows" transformation to keep only the rows where the "version" column contains the corresponding version for the selected month (e.g. "V04" for April) or a later version.

    After filtering the data from both tables, you can use the "Append Queries" transformation to combine the two tables into a single table. And make sure that the data types of the columns and the names of the column headers should be consistent. For specific explanations, see the following example and Note.

    Reference:

    Append queries - Power Query | Microsoft Learn

     

       

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.