Forum Discussion
Historic Data by Week Number, Creating a Current Week X-Axis
I'm struggling to get data to show correctly in any chart visual yet the data shows fine in a table format. Most likely because they are 2 seperate tables. Below is the chart as it previously existed...
Hi Anonymous,
Yes, I can.
Usually, only one date table is needed. Please refer to the snapshot below. There are two relationships while one is inactive.
// We don't need to use userealtionship() for the active relationship. _Incidents_Resolved = COUNTROWS(Incidents)
_Incident_Arrivals = CALCULATE ( COUNTROWS ( Incidents ), USERELATIONSHIP ( Added_Date[DATEKEY], Incidents[Added_Date_Key] ) )
Best Regards,
Hi Anonymous,
Yes, I can.
Usually, only one date table is needed. Please refer to the snapshot below. There are two relationships while one is inactive.
// We don't need to use userealtionship() for the active relationship. _Incidents_Resolved = COUNTROWS(Incidents)
_Incident_Arrivals = CALCULATE ( COUNTROWS ( Incidents ), USERELATIONSHIP ( Added_Date[DATEKEY], Incidents[Added_Date_Key] ) )
Best Regards,