Forum Discussion
Show rows between two dates from different tables
Hello, I have requirement where I need to show rows in table visual based on 2 date slicers. I have 2 tables with data like this. Table 1 ID Value Status Date FK_ID 1 2 ...
I have figure it out.
Hi Anonymous
Do you create any relationship between Table1 and Table2 in Power BI?
As for your example, i can't find the common rule from that.
Based on my assumption, the rule of your example is as below, please check if i understand you correctly,
1. startdate :2019-03-25, ReconDate:2019-03-25,
It show which "IssuedDate" <=startdate ??
2.startdate :2019-03-25, ReconDate:2019-03-28,
It show which "Claimed " <=ReconDate???
If i don't understand you correctly, please correct me.
Best Regards
Maggie
I have figure it out.