Create Date Table with Dynamic Language in Power Query

preview_player
Показать описание
You want to create a calendar that can switch between languages? So your English, Spanish and Chinese team can use the same calendar logic? This video has got you covered. You will learn an effective way to switch between languages for column values and column names.

WRITTEN ARTICLE

Master Functions and Syntax in M

CONTENTS
00:00 Introduction
01:36 Add Parameter
02:13 Transforming Column Values
10:14 Transforming Column Names

ABOUT BI GORILLA
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

#language #datetable #bigorilla
  1. BI Gorilla
Рекомендации по теме
Create Date Table 0:19:01

Create Date Table with Dynamic Language in Power Query

Dynamic Date Table 0:12:15

Dynamic Date Table Using the Power Query Editor

Creating a Dynamic 0:05:26

Creating a Dynamic Date Table in Power BI

Create Date Table 0:00:37

Create Date Table In Your Power BI Model With This Incredible Trick 📅🔥

Unleash the Power 0:03:53

Unleash the Power of Dates: Build a Dynamic Date Table in Power BI with a Single Query!

How to get 0:08:48

How to get a DATE TABLE easily in Power BI

DATE TABLE for 0:21:26

DATE TABLE for Power BI using Power Query

Dynamic Fiscal Year 0:12:12

Dynamic Fiscal Year Date Table using DAX in Power BI

Power BI Date 0:20:54

Power BI Date Table: A Comprehensive Tutorial to create dynamic Calendar

Power BI - 0:00:57

Power BI - Dynamic Date Table with Column

Creating a Dynamic 0:07:35

Creating a Dynamic Calendar Date Range in Power Query

Dynamic Start Date 0:06:18

Dynamic Start Date and End Date for Power BI Date Table

Create REUSABLE DYNAMIC 0:11:27

Create REUSABLE DYNAMIC Calendar Tables using Dataflows // Beginners Guide to Power BI in 2021

Power BI Create 0:00:38

Power BI Create a dynamic date table calendar in Power BI

Creating a Dynamic 0:05:08

Creating a Dynamic Date Table in Power BI

Use Power Query 0:10:03

Use Power Query to Create a Dynamic Calendar Table

Creating a Dynamic 0:09:08

Creating a Dynamic Date Query Table in Power BI - Query Editor Tutorial

Create a Dynamic 0:00:23

Create a Dynamic Date Table with CALENDAR DAX in Power BI #Shorts #PowerBI #DAX

NEW Date Picker 0:00:30

NEW Date Picker in Excel for Web‼️ #excel

Create a Dynamic 0:04:21

Create a Dynamic Date Table in Power Query with a Single Formula!

How to Generate 0:02:32

How to Generate Dynamic Date Table using M Code Power BI

Master the Art 0:07:42

Master the Art of Creating DYNAMIC Calendar Tables in Power BI | Power Query

Setting Up A 0:11:01

Setting Up A Dynamic Startdate And Enddate For Power Query Date Tables - Query Editor Tutorial

Today Formula in 0:00:15

Today Formula in Excel

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

Awesome! Thanks for walking through the steps. Thumbs up!!

wayneedmondson
Автор

Very nice! So, you say that if I build this before creating relationships and measures, it won't break? For example, if I create a visual that references one of the translatable columns, when I change the language, it won't break and throw an error that a column can't be found? Thanks again!

ricardorzm
Автор

Thanks for the clear and thorough explanation, Rick!

GrainneDuggan_Excel
Автор

and recently you showed how to connect to APIs
can you maybe help with translating words from a Table based ona language column using API in the 3rd column?

ExcelInstructor
Автор

Hi everybody, i want to ask if there is a way to renaming dynamically as in this video, but for column that are 'normal' and are not date, is it possible? thank you

andreadoro
Автор

Thank you for this! Super cool video! A+++

Iloveyou
join shbcf.ru