Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there, I'm pulling my hair out on this one, it seems obvious but I just can't find out how to do it....
Table_A contains an errorlog with a date column.
Table_B contains different items with lastrun_date = date column.
I want to filter Table_A on equal dates from (Table_B WHERE Table_B.item = x)
In T-SQL this would translate to:
SELECT * FROM Table_A WHERE Table_A.date = (SELECT Table_B.lastrun_date WHERE Table_B.item =x)
Can you please help me out?
Solved! Go to Solution.
Hi @Peter_ROC,
What's your data model like? If you can establish relationship between dates, the solution could be easy without a formula. You can check out the demo here.
Best Regards,
Dale
Hi @Peter_ROC,
What's your data model like? If you can establish relationship between dates, the solution could be easy without a formula. You can check out the demo here.
Best Regards,
Dale
Hi Dale,
That worked for me, thanks. I'm still curious how to catch this one in DAX, for future reference.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |