The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello folks,
I would like to display on a "line and clustered chart" the number of tickets opened and closed per year week.
First I have my data table that looks like this :
To do that, I followed the answer given in this topic LINK
I created a calendar table and I linked it to the "creation date" :
To finish, I created two columns in the table to put a 0 or 1 if closed or opened :
Hi @Anonymous ,
this happens because you connect to [Created date]. You need to add a new relationship between your two tables, between Calendar[Date] and Data[Closed date]. This second relationship will be inactive. In order to make use of it, you have to use the USERELATIONSHIP-function inside a measure, something like this
measureClosed = CALCULATE ( SUM ( Data[Closed] ); USERELATIONSHIP ( Data[Date Closure]; Calendar[Date] ) )
As for your cumulative count, it will depend a little on you Calendar-table, but in general it should look something like this
cumulative open = CALCULATE ( SUM ( data[open] ); FILTER ( ALL ( Calendar ); Calendar[Week] <= MIN ( Calendar[Week] ) && Calendar[Year] = MIN ( Calendar[Year] ) ) )
Cheers,
Sturla
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
12 | |
9 | |
7 |