Forum Discussion
Solved
how to use date form different tables (Direct Query)?
Hi all, need your help please. I have two tables,which are drawn with direct query to Power BI: Table 1 with columns Tickets Firm A, date and etc. Table 2 with Tickets Firm B, date and other colu...
Hi Jolyon,
Yes. You would need to create the new table in CRM, as we are not able to use "New table" feature in DirectQuery Mode.
Thanks,
Lydia Zhang
Hi Jolyon
use can do this:
1) create date table (one row for each day), look at CALENDAR DAX function
2) create relationship from both tables A and B to date table
3) add date axis to visual
4) add measures from A and measures from B to visual
no merged table needed :-)
HTH,
Frank