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
Thanks Pragati11 . I clicked on the advance editor and was able to get the code below :
I can see there is MinDate2 = List.Min(IncidentRawData[Raised on] and the MaxDate2 below it.
Does this mean that the date range auto populates when the data is refreshed and the "Raised On" date is extended?
Could you also advise how it would be possible to recreate this table to allow me to use this for other dashboards I am building?
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
Pragati11 I do not agree here with you to add a new calendar table using DAX is there is already one. Where do you think it is going to add value by adding a new calendar using DAX, especially if existing is already working and everything is developed on top of it? Just curious about your thought process.
- Thank you guys!
Thank you guys!
