i am trying to get the result as attached.
however i need the where clause for user to select their own date in power bi.

whenever i try to add date in where clause, i cant display the result as expected.
may i know do anyone have tips/clue on this?

[tabe1](https://i.sstatic.net/68gp0ZBM.png)
[table2](https://i.sstatic.net/JfliZmA2.png)
[expectation](https://i.sstatic.net/xpzArhiI.png)


SELECT 
    table1.team,
    table2.datee,
    table2.price
    from 
    table1 left join table2 on table1.team=table2.team 
    and table2.datee='2406'
    --where table2.datee='2406' --need this for users to input but will not display the result as expected