Forum Discussion
it Possible to do Dax Calculations when we use two Direct Query Tables?
Is it Possible to do Dax Calculations when we use two Direct Query Tables? I have two direct query data sources, am trying to create a calculated column using two fields from that. While using the ...
Hi athuiraps ，
DAX is available, but there are certain time intelligence DAX features that you cannot use such as every year, month over month, same period, and last year. to learn more direct query limitations,you could click here to read Official Article .
Also about the error you encountered， you must use RELATEDTABLE instead of related due to the relationship between Quarter dates and Effectivedatetable is one -> many.
refer :https://community.powerbi.com/t5/Desktop/Using-RELATED/m-p/7994
https://community.powerbi.com/t5/Desktop/Lookups-when-RELATED-doesn-t-work/m-p/1083795#M501870
Wish it is helpful for you!
Best Regards
Lucien