Create a DateKey YYYYMMDD format using DAX Format Function Power BI

preview_player
Показать описание
Published on Sep 16,2021:

In this video, we will learn to get a datekey in YYYYMMDD format using DAX format function.
DAX for the function is :
DimDate = ADDCOLUMNS( CALENDARAUTO(),"DateKey",FORMAT([DATE],"YYYYMMDD"))

SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!

Our Playists:

ABOUT DAGDOO:
Website:

Questions? Comments and SUGESTIONS? You will find me here:

Twitter: @dagdooe

Category: Science & Technology
License: Standard YouTube License
  1. Learn 2 Excel
  2. dax
  3. msbi
  4. powerpivot
  5. ssas
  6. sql server
Рекомендации по теме
Create a DateKey 0:01:36

Create a DateKey YYYYMMDD format using DAX Format Function Power BI

One minute info 0:00:59

One minute info Convert Date format to yyyymmdd

Change number in 0:00:24

Change number in date format | Excel formulas | Text Function

Quick Excel Convert 0:01:28

Quick Excel Convert Date Formats YYYYMMDD to DD/MM/YYYY

Unable to Change 0:03:41

Unable to Change Date Format in PowerBI ? Watch this | PowerBI Tutorial | MI tutorials

Query by example 0:01:42

Query by example YYYY MM

Convert a number 0:00:32

Convert a number column into a date column in Power BI

SQL : DATEDIFF 0:01:09

SQL : DATEDIFF working on yyyymmdd format SQL server

SQL : SQL 0:01:29

SQL : SQL convert yyyymmdd to timestamp in BigQuery?

Format DateTime in 0:00:59

Format DateTime in Power Query as per Custom Format

Change YYYY-MM-DD to 0:01:39

Change YYYY-MM-DD to YYYYMMDD everywhere in file (2 Solutions!!)

How to covert 0:03:05

How to covert Date format in power query | Locale function in powerbi| mm:dd:yy to dd:mm:yy

Power BI - 0:01:52

Power BI - UK date format DD-MM-YYYY error - SOLVED

Change Numbers to 0:02:52

Change Numbers to Date Format in PowerBI | MiTutorials

Custom date format 0:10:24

Custom date format in Excel

Power Query to 0:06:31

Power Query to Handle European Date Formats

Stop Creating Calendar 0:00:15

Stop Creating Calendar Tables | Power BI tips

How to change 0:03:36

How to change Power BI Date Format to US or UK date format

Split date to 0:01:05

Split date to multi column in excel

Change dates from 0:10:44

Change dates from mm dd to dd mm Format and Vice Versa

Convert a date 0:02:47

Convert a date from mm/dd/yy to dd/mm/yy

Power BI Tutorial 0:04:23

Power BI Tutorial Series for Beginners Part 88: Power Query - Date.FromText, Date.ToText

Power BI Date 0:06:21

Power BI Date Format Change and adding Date to Slicer

PowerQuery Locale for 0:08:36

PowerQuery Locale for dates not working?

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

well it still reads this new column as a text. It is not gonna help if we want use it as a slicer.

aleksanderukaszewski
Автор

Hi There,
Quick question! My model doesn't have date column but it's having month and year, how can I get actual and forecast values based on my filter selection on month.

mchandrasekhar