Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Filter table based on another table

  • 1.  Filter table based on another table

    Posted 23 days ago

    Hi, guys! I need some help. I have small task for my pbi project: select data only if persist in table. I have tables: Production, Supply, Tenders. Production is main table, this table consist of such columns: id, data (last month is september), district, weight.Tables supply,tenders contain id,data,weith, sum.

    I must selecting data from Supply and Tenders only to September. When production table is will update, select data from last month for my table.



    ------------------------------
    Vladislav Alyushin
    4951234567
    ------------------------------
    Conference-PBI_200x200


  • 2.  RE: Filter table based on another table

    Top Contributor
    Posted 22 days ago
    Hi @Vladislav Alyushin,

    Have you tried parameters in Power Query​?

    You can get the last date of your production as a function and use that to filter other tables.

    I'll try to work on an example from one of my files that I can share and send it.

    Thank you,

    ------------------------------
    Vishesh Jain
    Owner
    VR Construction
    ------------------------------

    Conference-PBI_200x200


  • 3.  RE: Filter table based on another table

    Posted 22 days ago
    It would be nice, if you share same example

    ------------------------------
    Vladislav Alyushin
    4951234567
    ------------------------------

    Conference-PBI_200x200