Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

left join in tabular model

I Have a situation where cross join and left joins are involved.I want to implement the below query in tabular model.I have managed till cross join using Dax -Cross join (tableI,tableT) and joined al...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous,

 

Here I think we can use NATURALLEFTOUTERJOIN and CALCULATETABLE to work on it. Could you please share your sample data and excepted result to me, if you don't have confidential data? Please upload your file to One Drive and share the link here.

 

Regards,

Frank