https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Temporal-evolution-chart-by-many-date-columns/m-p/3072010#M156902 <P>Hello, need to find a way to create a temporal evolution chart, my table looks like this:</P><P><BR />ID&nbsp; Status&nbsp; &nbsp; &nbsp; &nbsp;Created&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Closed&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Updated&nbsp; &nbsp; &nbsp; &nbsp; Snapshot<BR />1&nbsp; &nbsp; New&nbsp; &nbsp; &nbsp; &nbsp; 01/02/2022&nbsp; &nbsp; 20/05/2022&nbsp; 04/02/2022&nbsp; &nbsp; 14/02/2022<BR />1&nbsp; &nbsp; New&nbsp; &nbsp; &nbsp; &nbsp; 01/02/2022&nbsp; &nbsp; 20/05/2022&nbsp; 04/02/2022&nbsp; &nbsp; 22/02/2022<BR />1&nbsp; &nbsp;ToDO&nbsp; &nbsp; &nbsp; &nbsp;01/02/2022&nbsp; &nbsp; 20/05/2022&nbsp; 25/02/2022&nbsp; &nbsp; 11/03/2022<BR />1&nbsp; &nbsp;Review&nbsp; &nbsp; &nbsp;01/02/2022&nbsp; &nbsp;20/05/2022&nbsp; &nbsp;11/04/2022&nbsp; &nbsp; 15/03/2022<BR />1&nbsp; &nbsp;Closed&nbsp; &nbsp; &nbsp;01/02/2022&nbsp; &nbsp;20/05/2022&nbsp; &nbsp; 20/05/2022&nbsp; &nbsp; &nbsp;22/05/2022<BR />1&nbsp; &nbsp;Closed&nbsp; &nbsp; &nbsp;01/02/2022&nbsp; &nbsp; 20/05/2022&nbsp; &nbsp;15/06/2022&nbsp; &nbsp; 24/06/2022<BR />1&nbsp; &nbsp;Closed&nbsp; &nbsp; 01/02/2022&nbsp; &nbsp; 20/05/2022&nbsp; &nbsp; 15/06/2022&nbsp; &nbsp; 12/07/2022<BR />1&nbsp; &nbsp; &nbsp; &nbsp;...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23/08/2022<BR />2&nbsp; &nbsp; ToDo&nbsp; &nbsp; &nbsp;02/04/2022&nbsp; &nbsp; 11/07/2022&nbsp; &nbsp; 05/03/2022&nbsp; &nbsp; &nbsp;15/03/2022<BR />2&nbsp; &nbsp;Review&nbsp; &nbsp;02/04/2022&nbsp; &nbsp; 11/07/2022&nbsp; &nbsp; &nbsp;02/05/2022&nbsp; &nbsp; 22/05/2022<BR />2&nbsp; &nbsp;Closed&nbsp; &nbsp; 02/04/2022&nbsp; &nbsp;11/07/2022&nbsp; &nbsp; &nbsp;11/06/2022&nbsp; &nbsp; &nbsp;24/06/2022<BR />2&nbsp; &nbsp;Closed&nbsp; &nbsp; 02/04/2022&nbsp; &nbsp;11/07/2022&nbsp; &nbsp; &nbsp;11/06/2022&nbsp; &nbsp; &nbsp;12/07/2022<BR />2&nbsp; &nbsp; &nbsp; &nbsp;...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23/08/2022<BR />3&nbsp; Closed&nbsp; &nbsp; 12/05/2022&nbsp; &nbsp; &nbsp;21/08/2022&nbsp; &nbsp; &nbsp;21/05/2022&nbsp; &nbsp; &nbsp;22/05/2022<BR />3&nbsp; Closed&nbsp; &nbsp; 12/05/2022&nbsp; &nbsp; 21/08/2022&nbsp; &nbsp; &nbsp;21/05/2022&nbsp; &nbsp; &nbsp; 24/06/2022<BR />3&nbsp; Closed&nbsp; &nbsp; 12/05/2022&nbsp; &nbsp; 21/08/2022&nbsp; &nbsp; &nbsp; 21/05/2022&nbsp; &nbsp; &nbsp;12/07/2022<BR />3&nbsp; &nbsp; &nbsp;...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23/08/2022</P><P>&nbsp;</P><P>Updated is a date when something is changed in that ticket, can be anything, even in other columns which i didn't specified here.<BR />Snapshot is just a date to cumulate info about a ticket, i'm using this column to calculate how many tickets were closed from the beggning of the collection.<BR />What's the best approch if i want to display a single Line Chart with: a number of tickets that are new(prefered to use the [Created] column because a ticket will not necessary have a status of "New"), number of tickets that are closed and others for different statuses.</P> Thu, 09 Feb 2023 14:02:52 GMT uif19085 2023-02-09T14:02:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Temporal-evolution-chart-by-many-date-columns/m-p/3072010#M156902 <P>Hello, need to find a way to create a temporal evolution chart, my table looks like this:</P><P><BR />ID&nbsp; Status&nbsp; &nbsp; &nbsp; &nbsp;Created&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Closed&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Updated&nbsp; &nbsp; &nbsp; &nbsp; Snapshot<BR />1&nbsp; &nbsp; New&nbsp; &nbsp; &nbsp; &nbsp; 01/02/2022&nbsp; &nbsp; 20/05/2022&nbsp; 04/02/2022&nbsp; &nbsp; 14/02/2022<BR />1&nbsp; &nbsp; New&nbsp; &nbsp; &nbsp; &nbsp; 01/02/2022&nbsp; &nbsp; 20/05/2022&nbsp; 04/02/2022&nbsp; &nbsp; 22/02/2022<BR />1&nbsp; &nbsp;ToDO&nbsp; &nbsp; &nbsp; &nbsp;01/02/2022&nbsp; &nbsp; 20/05/2022&nbsp; 25/02/2022&nbsp; &nbsp; 11/03/2022<BR />1&nbsp; &nbsp;Review&nbsp; &nbsp; &nbsp;01/02/2022&nbsp; &nbsp;20/05/2022&nbsp; &nbsp;11/04/2022&nbsp; &nbsp; 15/03/2022<BR />1&nbsp; &nbsp;Closed&nbsp; &nbsp; &nbsp;01/02/2022&nbsp; &nbsp;20/05/2022&nbsp; &nbsp; 20/05/2022&nbsp; &nbsp; &nbsp;22/05/2022<BR />1&nbsp; &nbsp;Closed&nbsp; &nbsp; &nbsp;01/02/2022&nbsp; &nbsp; 20/05/2022&nbsp; &nbsp;15/06/2022&nbsp; &nbsp; 24/06/2022<BR />1&nbsp; &nbsp;Closed&nbsp; &nbsp; 01/02/2022&nbsp; &nbsp; 20/05/2022&nbsp; &nbsp; 15/06/2022&nbsp; &nbsp; 12/07/2022<BR />1&nbsp; &nbsp; &nbsp; &nbsp;...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23/08/2022<BR />2&nbsp; &nbsp; ToDo&nbsp; &nbsp; &nbsp;02/04/2022&nbsp; &nbsp; 11/07/2022&nbsp; &nbsp; 05/03/2022&nbsp; &nbsp; &nbsp;15/03/2022<BR />2&nbsp; &nbsp;Review&nbsp; &nbsp;02/04/2022&nbsp; &nbsp; 11/07/2022&nbsp; &nbsp; &nbsp;02/05/2022&nbsp; &nbsp; 22/05/2022<BR />2&nbsp; &nbsp;Closed&nbsp; &nbsp; 02/04/2022&nbsp; &nbsp;11/07/2022&nbsp; &nbsp; &nbsp;11/06/2022&nbsp; &nbsp; &nbsp;24/06/2022<BR />2&nbsp; &nbsp;Closed&nbsp; &nbsp; 02/04/2022&nbsp; &nbsp;11/07/2022&nbsp; &nbsp; &nbsp;11/06/2022&nbsp; &nbsp; &nbsp;12/07/2022<BR />2&nbsp; &nbsp; &nbsp; &nbsp;...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23/08/2022<BR />3&nbsp; Closed&nbsp; &nbsp; 12/05/2022&nbsp; &nbsp; &nbsp;21/08/2022&nbsp; &nbsp; &nbsp;21/05/2022&nbsp; &nbsp; &nbsp;22/05/2022<BR />3&nbsp; Closed&nbsp; &nbsp; 12/05/2022&nbsp; &nbsp; 21/08/2022&nbsp; &nbsp; &nbsp;21/05/2022&nbsp; &nbsp; &nbsp; 24/06/2022<BR />3&nbsp; Closed&nbsp; &nbsp; 12/05/2022&nbsp; &nbsp; 21/08/2022&nbsp; &nbsp; &nbsp; 21/05/2022&nbsp; &nbsp; &nbsp;12/07/2022<BR />3&nbsp; &nbsp; &nbsp;...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23/08/2022</P><P>&nbsp;</P><P>Updated is a date when something is changed in that ticket, can be anything, even in other columns which i didn't specified here.<BR />Snapshot is just a date to cumulate info about a ticket, i'm using this column to calculate how many tickets were closed from the beggning of the collection.<BR />What's the best approch if i want to display a single Line Chart with: a number of tickets that are new(prefered to use the [Created] column because a ticket will not necessary have a status of "New"), number of tickets that are closed and others for different statuses.</P> Thu, 09 Feb 2023 14:02:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Temporal-evolution-chart-by-many-date-columns/m-p/3072010#M156902 uif19085 2023-02-09T14:02:52Z