PBI file with dax pattern formulas

[George1]

Hi

I am a long time listener first time caller. I have just been watching Sam’s content “Using ChatGPT To Supercharge Power BI Development” which has been really good. In the content Sam references his own template pbi file which includes all his dax formula patterns and date table etc. Would it be possible to have access to this template file (if it isnt already on the platform somewhere…)?

Cheers
George

[EnterpriseDNA]

Hi @George1,

You may find the DAX Formula Reference Guide on your dashboard under resources.
or you mat follow this link: https://app.enterprisedna.co/app/resources

For the date table, you mat refer to these forum post by Melissa

Extended Date Table (Power Query M function)

Hi everyone, To make it easier to find I’ve placed the updated Power Query M code function for the extended Date Table / Dates Table in the category where it belongs… I hope you’ll find it useful and if there are any questions, just reach out and let me know! // August 2022 There has been an overhaul of the M code from when it was initially shared. This affects column names and values. In the Analyst Hub (follow this link) you can copy a version of Extended Date table which returns a r…

Basic Date Table (Power Query M function)

Hi all, There have been requests for a basic Date table that includes week logic centered around the start- / end of week dates AND/OR fiscal weeks. Both will start on the selected Start of week day but the first creates weeks of 7 days when crossing over into the next calendar year and the second weeks with <= 7 days around each fiscal year start and -enddate, as illustrated below. . [image] . Copy this M code script into a new blank query. let fnDateTable = (StartDate as date, EndDate …

Thank you!

[George1]

Hi

I was more after a reference file to formular patterns (ie cummulative sales, moving average etc…) rather than a guide on the DAX functions. It looked like the file that was used in the video had a whole of lot of pattern formulars. Is that available anywhere?

Thanks
G

[Keith]

Hi @George1,

I know what you are talking about. The file that he is using is a template pbix file that he has everything created before starting a new model. I don’t see it any place on the portal and i don’t think it will be shared.

You will likely have create that yourself.

I source for you could use to get that started is the analyst hub. People put some of their dax coding formula there for others to reference off.

I hope this helps to get you started.

Thanks
Keith

[ystroman]

Hi @George1, the Analyst Hub is an excellant resource, and has has a lot of formula patterns. I would also recommend DAX Patterns for their extensive DAX pattern collection that is usually the baseline resource along with that of EnterpriseDNA.

[George1]

Okay thanks for the replies Keith & ystroman