Forum Discussion
Helper IIIWhat are the date columns fields required for subscription based company
Hello everyone,
We are switching to Power BI from Excel-based reports.
Snowflake is the source.
For this, I now want to create a centrailized date table. I have a field called CreatedDate.
Should I make a Power BI Calendar Table or a Snowflake View?
We have rolling months, YOY, MOM, and QOQ.
Expansion, Churn, EOD, New Units, and EOP Units are all calculated.
Would you kindly advise on the best method for creating the table?
| MoM | MoM | MoM | MoM | MoM | MoM | YOY | YOY | YOY | YOY | YOY | YOY | |
| Jan-25 | Feb-25 | Mar-25 | Apr-25 | May-25 | Jun-25 | Jan-25 | Feb-25 | Mar-25 | Apr-25 | May-25 | Jun-25 |
The recommended best practice is to create the Date table at the source (e.g., in Snowflake) and use it in Power BI. However, you can also create a Date table directly in Power BI using DAX. You can refer to the link below for guidance.
https://www.youtube.com/watch?v=-li7sxUxEqA
3 Replies
jgeddesSuper User
The best practice would be to make the server do as much work as possible for you. It will speed up your report in the end. Second option is to build the table in Power Query. Last option should be creating the table in DAX.
- AnkitaaMishra
The recommended best practice is to create the Date table at the source (e.g., in Snowflake) and use it in Power BI. However, you can also create a Date table directly in Power BI using DAX. You can refer to the link below for guidance.
https://www.youtube.com/watch?v=-li7sxUxEqA Hi Gopal_PV ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.
