Forum Discussion
extend existing date range
Hi Anonymous ,
Yes the data is auto updated in your case as it is coming from "Raised On" date.
You can try creating a calendar table in Power BI. Refer following link:
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi Anonymous ,
This looks like a Calendar date table created in Power BI.
In Power BI as shown below:
On the right go to your Date table, on the top it shows you the way this table is created. If it is a date table created using CALENDAR function, you can modify the date range as shown above. This function takes StartDate ansd EndDate as inputs.
You can modify them as required.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Pragati11 it could be created in Power Query as well, and that's the reason I asked Anonymous to check it first how it is created, Yes if it is created in DAX, you solution will work but we are not there yet, Just my feedback.
And it could be coming from the backed data source, you never know.