Forum Discussion
Create a dynamic table adding a new line every day
I want to create a table with values a produce every day.
Every new day i want the old values to be kept with the day the were produced and a new line should be added with the newvalues.
In the end a table will be created with values which are produced and are unique for every day.
2 Replies
- amitchandak
Super User
Anonymous , You can create such table in dax using calendar
calendar(Date(2021,01,01), Toady())
you can use addcolumns to add some logic have values
the difficult part is to archive the value of the previous day.
The value of the previous day is no longer available the current day of the report so it has to be archived
in the 13/07/2022 i will not longer know the pipeline of the 12/07/2022.
So i will have to create a table adding the last available value every day
