Adding Parameter in Data Table M Function - Query Editor Tutorial

preview_player
Показать описание
This video is going to Illustrate how to set up and incorporate an additional Parameter to the Power Query Date Table M function.

Hope you enjoy this one

Melissa

***** Video Details *****
1:45 copy the date table M function from the M Showcase Category in the Enterprise DNA Forum
2:00 the Extended Date Table in the forum
2:19 set up logic in a new blank Query and
5:51 create a logical test using List.Contains
7:55 incorporate the fcorrect logic into Distinct.Table
9:14 invoke the query

****** Learning Power BI? *****

***** Related Links *****

***** Related Course Modules *****

***** Related Support Forum Posts *****
  1. Enterprise DNA
  2. Power BI
  3. Power BI DAX
  4. Enterprise DNA
  5. Sam Mckay
  6. Power BI Tutorial
Рекомендации по теме
Adding Parameter in 0:10:49

Adding Parameter in Data Table M Function - Query Editor Tutorial

Excel Power Query 0:20:25

Excel Power Query Parameter from a Cell Value (using a Named Range or a Table)

Create A Parameter 0:06:59

Create A Parameter Table For Your Power Queries

Excel What-If Analysis 0:08:42

Excel What-If Analysis Data Table | Easy to Use Once you Learn This☝️

Fields Parameter in 0:15:14

Fields Parameter in Action I Practical Examples

How to make 0:04:04

How to make a two way (two variable) data table in Excel

Making data source 0:03:28

Making data source parameters easy in Power BI Desktop

Adding New Parameter 0:09:53

Adding New Parameter and Data Table on your system

How To Use 0:19:23

How To Use AWS Lambda Python Functions In Appsmith

How To Use 0:07:07

How To Use Query Parameter In Power BI [2023 Update]

Power Query Parameters 0:12:14

Power Query Parameters - Dynamically Change the Output of Your Queries Depending on Their Value

Dynamic Field Parameter 0:05:57

Dynamic Field Parameter Grouping - How To Grab The Source Table Name

Create Static Tables 0:13:38

Create Static Tables in DAX Using the DATATABLE Function

Datatable - dom 0:06:28

Datatable - dom Parameter

Learn how to 0:00:16

Learn how to create a parameter in Tableau and link with top n filter. Watch full video on Channel!

Creating a Parameter 0:03:48

Creating a Parameter in Tableau

Send datatable as 0:09:27

Send datatable as parameter to stored procedure

Oracle BI Publisher 0:10:34

Oracle BI Publisher : Add a Parameter to the Report

MSPTDA 20: Query 0:11:07

MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Q...

Select a Measure 0:00:54

Select a Measure using a Slicer | Fields Parameter Trick in Power BI

Power BI - 0:00:27

Power BI - Matrix Visualization - move values from columns to rows

Filter by Parameter 0:10:50

Filter by Parameter and Dynamic Drop-Downs with Power Query | Everyday Office

Create a date 0:07:13

Create a date range parameter with Power query | Powerful Tricks to save your time in power query

Pass parameter to 0:04:34

Pass parameter to table in Jasper Report

Комментарии
Автор

Very useful. The pace is just right for me with excellent explanations. Thanks so much, Melissa.

EricaDyson
Автор

Great video Melissa, Thanks for sharing.
Our Shift patterns run Sunday to Saturday working week over a 24 hour pattern 364 days of the year (Production)
Is there any videos that you can recommend or tips for setting Sunday as day 1 and Saturday as day 7?
Thanks and keep the videos coming !

darrengodkin
Автор

Learning Power BI?

Related Links

Related Course Modules

Related Support Forum Posts

EnterpriseDNA