Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 en...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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