Forum Discussion
WTD MTD YTD table
Hello community. Currently we are migrating data from Snowflake to dataflow/datamart. We have several dashboards where we are using the above manual table as a reference table. Is there a w...
Hi! Here is a blog I wrote about my favorite date ref table from SQLBI. There is a link to their DAX table in my article. The Custom Date Table Edition – Power BI with Me
Once you have a robust date table you can use DAX time intelligence functions to create your YTD, QTD, MTD, R7, etc. measures.
audreygerred
Super User
Super UserHi! Here is a blog I wrote about my favorite date ref table from SQLBI. There is a link to their DAX table in my article. The Custom Date Table Edition – Power BI with Me
Once you have a robust date table you can use DAX time intelligence functions to create your YTD, QTD, MTD, R7, etc. measures.