Hi, I need your help in the scenario that I would like to get data from many tables.
I have too much source from other tables like an example that I am giving you here.
| Username | Logon Time | Month | | Username | Logon Time | Month | | Username | Logon Time | Month |
| A | 1115 | Jan18 | | A | 1235 | Jan19 | | A | 1113 | Jan20 |
| B | 1232 | Jan18 | | B | 1112 | Jan19 | | B | 1654 | Jan20 |
| C | 1143 | Jan18 | | C | 1432 | Jan19 | | C | 1545 | Jan20 |
| D | 333 | Jan18 | | D | 455 | Jan19 | | D | 654 | Jan20 |
Total 3823 Total 4233 Total 4966
So now my requirement is how to get the data from each table to the table below that I create in Power BI.
I have known how to lookup from one table to one field
Such as in 2018 Month: Jan and then get the logon time from Jan18 total to this field.
| Month | Logon Time |
| Jan-18 | Total |
| Jan-19 | Total |
| Jan-20 | Total |
Could you please, give me how to write DAX to get data from many tables?
Thank you.
