Forum Discussion

Surekha_PM's avatar
Surekha_PM
Resolver I
1 year ago
Solved

Repeat data for the missing date

Hello Everyone, I am creating a word cloud for text data in my dashboard. I am receiving the data on random days. There is no exact gap in the date when I am receiving the data. For example, th...
Need Help
  • Surekha_PM's avatar
    Surekha_PM
    1 year ago

    Thank you jaineshp & Rupak_bi,

    I actually took a different approach to solve the issue. I created a new table with a calendar date till today. And then did a lookup and pasted the data in that new table. Now in the new table I am able to see the data for every day. This is showing me correct data, so I am continuing with this. But I really appreciate your response. Thank you for the suggestion.

    Regards,
    Surekha

Rupak_bi's avatar
Rupak_bi
Super User
1 year ago

Hi Surekha_PM ,

Considering in the original dataset you have columns , Date and Data.
1. Now create a calculated table with all dates

table = calender(date(2025,1,1),date(2025,12,31))

2. Create a new column as below

latest data = 
var last_date = calculate(max(main_table,date),all(main_table),main_table,Date<=new_tabe,Date)
result
calculate(max(main_table,Data),main_table,Date = last_date)

Hope this will work. if not, please share sample data to better understand the pattern and model.