ContosoSalesForPowerBI: 'https://download.microsoft.com/download/4/6/A/46AB5E74-50F6-4761-8EDB-5AE077FD603C/Contoso%20Sales%20Sample%20for%20Power%20BI%20Desktop.zip 'https://www.youtube.com/watch?v=IsTC8zHR-hY
Category: Data Analysis
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