Power BI – Create Date table

How to Create Date Tables in Power BI Tutorial: 'https://www.datacamp.com/tutorial/how-to-create-date-tables-in-power-bi-tutorial Table script:Date_table = CALENDAR(min(Sheet[Visit Date]), MAX(Sheet[Visit Date])) M-code Script ref: https://youtu.be/yAGuOaJkevs?t=903create new tables as datesTable using below M-query code:in powerquery > new Source > blank Query> advanced Editor > {paster below Mquery code} let fnDateTable = (StartDate as date, EndDate as date, FYStartMonth as number) … Continue reading Power BI – Create Date table