Create Your Own Date Table Using Power Query And Gpt4

A Calendar (Date) table is critical for building Power BI or Excel Power Pivot Reports.

GPT4 can help us create the columns we need.

Link to Video explaining Why and How to use a Calendar
youtu.be/LfKm3ATibpE

Link to downloadable Calendar
accessanalytic.com.au/free-excel-stuff/free-excel-templates/

Link to GTP4 Prompt
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EtqKraCasAxPiSIIKpQRYxABJvMlxwo92Ayi4HzVSMKFEg?e=DE8lWI

00:00 Introduction
00:31 Overview and intro to GPT4 including the importance of a prompt
02:29 Extracting month name and number
03:25 Determining financial year as June
04:34 Obtaining financial month number
05:48 Adding parameter for changing financial year
06:14 Hiding Financial Year fields if 0 entered as Month Number

The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. accessanalytic.com.au/

Did you know I've written a book "Power BI for the Excel Analyst"?
pbi.guide/book/

Connect with me
wyn.bio.link/

Author

Ariyani

Como educador, estou profundamente engajado no desenvolvimento dos estudantes em ambiente escolar, adotando métodos pedagógicos que valorizam conexões genuínas e são movidos por inovação e fervor. É minha vocação guiar os alunos na jornada de se tornarem uma geração notável, empregando estratégias de ensino amplamente aclamadas por prestigiadas instituições acadêmicas ao redor do globo - preview.pbjmanagement.co.uk