Forum Discussion
Repeat data for the missing date
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
Hi Surekha_PM ,
Yes, this can be accomplished in Power BI using a combination of calendar table and DAX measures.
Step-by-Step Approach:
1. Create a Calendar Table
- Generate a continuous date table covering your full date range
- Include all dates from your earliest data point to current/future dates
2. Establish Relationship
- Link your calendar table to your data table using the date field
- Ensure proper one-to-many relationship is established
3. Build DAX Measure for Last Available Data
Last Available Text =
VAR SelectedDate = MAX('Calendar'[Date])
VAR LastDataDate =
CALCULATE(
MAX('YourDataTable'[Date]),
'YourDataTable'[Date] <= SelectedDate
)
RETURN
CALCULATE(
CONCATENATEX('YourDataTable', 'YourDataTable'[TextColumn], " "),
'YourDataTable'[Date] = LastDataDate
)
4. Configure Word Cloud Visual
- Use the DAX measure as your text source instead of direct column
- Set up date slicer using the calendar table
- The word cloud will now show last available data for any selected date
5. Additional Considerations
- Handle null scenarios with ISBLANK() checks in your DAX
- Consider performance optimization for large datasets
- Test thoroughly with various date selections
This approach ensures users always see relevant word cloud data regardless of the selected date, pulling from the most recent available dataset when no exact match exists.
Did it work? ✔ Give a Kudo • Mark as Solution – help others too!
Best regards,
Jainesh Poojara / Power BI Developer