Create Calendar Date Table - for Dashbord Reporting
E
Esther craft
The features in the Calandar Date table - should be simialir like Power Query - https://www.youtube.com/watch?v=rlGsfsb-_t4 (refer to this you tube link here)
SHould allow us to create easily Date, Weeks, Month, Quarter, Year, Month Type eg: Previous month, current month , Next month
Purpose would be to show progress status of projects on month on month basis or Wk on Wk basis;
Last month 50 open projects
This month 35 Open Project and 5 New Projects
INtegrations could be excel - we could build our Calandar Date Table in Excel and Import it - then use it for our Dashboards reporting
Similair functions in Power BI (where date table is needed)
Thanks Jon for your questions
Jon Darbyshire
Hiya Esther craft, thanks for this post! I have a few more questions for you:
- What specific features or functionalities would you like to see in the Calendar Date Table for it to be most useful in your reporting?
- How frequently do you anticipate using the Calendar Date Table in your dashboard reporting?
- Are there any specific integrations or data sources that the Calendar Date Table should support to enhance its utility?