What are the date columns fields required for subscription based company

[Gopal_PV]

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

[v-nmadadi-msft]

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.

[AnkitaaMishra · Accepted solution]

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

[jgeddes]

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.