Forum Discussion
jarwest
Helper II
Helper IIFiltering Data Based on a Date Table and 2 Date Columns in a Second Table
Hey all, I have a table with 2 date columns, DateBought and DateSold. Every item in the report will have a date bought value, since all items in the date were bought, but items that have not been so...
amitchandak
Super User
Super Userjarwest , You need to create a date table and join both dates with that. One join will be active and one will be inactive, you can use userelationship in measure to activate the join
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
jarwestWouldn't that filter if both dates are in range? I need to filter on if DateBought or DateSold are in this range, but if I understand this correctly it would filter on if DateBought and DateSold are in this range.