Forum Discussion
DirectQuery Dax - Dates comparison
Hi Team, I need help with transformation of a Dax calculation which works in Import mode, but it’s not applicable to Direct query mode. I have three tables, currently used in Import mode, but I...
Hey Anonymous ,
my recommendation if you move to DQ, create a single table instead of using a 1:1 relationship between the tables Locations1 and Locations2.
Ask the owner of the data source if they can provide this table or a view that combines both tables into a single table.
If this does not work, please provide sample data that can be easily imported into a SQL tables.
Regards,
Tom
Hi TomMartens ,
Currently it is not possible to combine the two tables, I will bring this to the owner.
I uploaded the three excel files for Locations1&2,Tasks: https://drive.google.com/drive/folders/1-SRRo_3gopc_d4LF-EpU2D3Y4TBNb4GO?usp=sharing
Please let me know if anything else is needed. Thank you for looking into my case.