Forum Discussion
Graphing two counts onto same visual with multiple date columns
- 4 years ago
katemke , If they are two tables - no column, with date table you can have two active join and you can work with count and sum measures from both tables
If they two dates from one table. One inactive relationship need to be activated using userelationship
And you need use common date from date table on slicer and axis
example
calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Table'2[CreateDate], 'Date'[Date]))
katemke , If they are two tables - no column, with date table you can have two active join and you can work with count and sum measures from both tables
If they two dates from one table. One inactive relationship need to be activated using userelationship
And you need use common date from date table on slicer and axis
example
calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Table'2[CreateDate], 'Date'[Date]))