https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Historical-data-runchart/m-p/3066360#M156883 <P>Hello community,</P><P>&nbsp;</P><P>i´m setting up a report for a ticketing-system. power bi is connected directly to the SQL database of the ticketing-system.</P><P>&nbsp;</P><P>i´d like to realize a kind of a historical runchart. for example: every day at 11:00pm an automatical data-dump should be made, so i will be able to create a runchart were i can see the amount of tickets at 11:00pm from yesterday, the day before yesterday etc.</P><P>&nbsp;</P><P>How is this possible in power bi?</P><P>&nbsp;</P><P>Regards</P> Tue, 07 Feb 2023 14:09:18 GMT BluSonic 2023-02-07T14:09:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Historical-data-runchart/m-p/3066360#M156883 <P>Hello community,</P><P>&nbsp;</P><P>i´m setting up a report for a ticketing-system. power bi is connected directly to the SQL database of the ticketing-system.</P><P>&nbsp;</P><P>i´d like to realize a kind of a historical runchart. for example: every day at 11:00pm an automatical data-dump should be made, so i will be able to create a runchart were i can see the amount of tickets at 11:00pm from yesterday, the day before yesterday etc.</P><P>&nbsp;</P><P>How is this possible in power bi?</P><P>&nbsp;</P><P>Regards</P> Tue, 07 Feb 2023 14:09:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Historical-data-runchart/m-p/3066360#M156883 BluSonic 2023-02-07T14:09:18Z