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,
v-jiascu-msft Again Thanks. The 2 date tables are there as a colleague suggested as we can't use the one date table to relationshiop between both dates hence 2 tables.
I will now go away and prep a file i can share