Forum Discussion
Pull data from multiple tables
Hi Eyelyn, the shortened DAX did help but I ended up merging the two tables into a new table to resolve my issue with pulling data from two tables. Thanks for responding.
Hi Anonymous ,
If there is a relationship between MERGE_BillingSUMMARY table and MERGE_Observations table? Actually we need more details about your tables to help us clarify your scenario. You could create a dummy sample for us to test or
share your pbix file after removing sensitive data.
Refer to:
How to Get Your Question Answered Quickly - Microsoft Power BI Community
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
In addition, Your [Compliant Patient] may be simplified:
Compliant Patient =
IF(MERGE_BillingSUMMARY[*Blood Test Met]=1 && MERGE_Observations[*MH Met]=1, "Compliant","Not Compliant")
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Eyelyn, the shortened DAX did help but I ended up merging the two tables into a new table to resolve my issue with pulling data from two tables. Thanks for responding.