Forum Discussion
Filter two columns with one date table
I have a model in sql server analysis services connected to power bi with three dimension tables(vendor, customer and date) and one fact table(sales). In the sales table i have sales date, vendor, customer and sales.
Now i have to add a new column in the fact table(connection date). This column shows when customer and vendor started working together. The user should be able to filter based on sales date and connection date. For the purpose i am planning to create a second date table for the connection date filter. My question is is it possible to filter sales date and connection date based only on one date table or creating a second date table is inevitable?
Thanks
ivanmezev , if you want select say month and date and want both sales date and connection date to filter on same period you can use common date table with inactive join with one date and use relationship
if you want to filter sales and connection dates on different periods then you need two date tables
userelationship example
1 Reply
- amitchandak
Super User
ivanmezev , if you want select say month and date and want both sales date and connection date to filter on same period you can use common date table with inactive join with one date and use relationship
if you want to filter sales and connection dates on different periods then you need two date tables
userelationship example