Forum Discussion
How to add data on a linear graph by two date
Hello,
The typical way of handling this is to have a Date table, and create
- An active relationship between one of your date columns (say Submission Date) and the Date table
- And an inactive relationship between the other date column (say Approval Date) and the Date table
Assuming the active relationship is with Submission Date, you would create measures something like this using USERELATIONSHIP to activate the inactive relationship (I'm assuming COUNTROWS makes sense as a measure):
Submissions Count = COUNTROWS ( Submissions ) Approval Count = CALCULATE ( COUNTROWS ( Submissions ), USERELATIONSHIP ( Submissions[Approval Date], 'Date'[Date] ) )See these two pages for good explanations:
https://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/
https://blog.enterprisedna.co/2017/10/16/working-with-multiple-dates-in-power-bi/
Hello,
The typical way of handling this is to have a Date table, and create
- An active relationship between one of your date columns (say Submission Date) and the Date table
- And an inactive relationship between the other date column (say Approval Date) and the Date table
Assuming the active relationship is with Submission Date, you would create measures something like this using USERELATIONSHIP to activate the inactive relationship (I'm assuming COUNTROWS makes sense as a measure):
Submissions Count =
COUNTROWS ( Submissions )
Approval Count =
CALCULATE (
COUNTROWS ( Submissions ),
USERELATIONSHIP ( Submissions[Approval Date], 'Date'[Date] )
)See these two pages for good explanations:
https://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/
https://blog.enterprisedna.co/2017/10/16/working-with-multiple-dates-in-power-bi/