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,
Can you share your file? Please mask the sensitive parts first.
Why are there so many date tables like Added_Date, Colsed_Date? Only one date table is needed.
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,
Hi Anonymous ,
Could you please mark the proper answers as solutions?
Best Regards,
v-jiascu-msft Hello, I have just got around to testing this out. I will now mark the accepted solution
Thanks Again