Excel PQ and PP - Convert YearMonth to Data
In this video we will see how to convert the value YearMonth to Date, we will do it with Excel formulas, with PowerQuery, with PowerPivot calculated fields and with PowerPivot measures.
============ INVEST IN YOUR TRAINING =================
Are you looking to improve your skills and obtain a digital certificate of attendance?
My Masterclasses offer exclusive content and a complete learning experience. By purchasing from my site you will also have access to exclusive discounts.
Don't miss the opportunity to grow professionally.
https://www.bi4you.it/masterclass/
=========== SUBSCRIBE ON YT =================
Subscribe to this channel to access the benefits: / @lodovicodincau
======= SAFE AND AFFORDABLE SOFTWARE! ==
CyberGhost VPN/Antivirus TOP: https://www.cyberghostvpn.com/offer/B...
Windows, Office, WindowsServer, SQL Server: https://mrkeyshop.com/it/?MrKey=484
======= MY GEAR ===============
Mouse: https://amzn.to/3Tnu1Kk
Yeti Microphone: https://amzn.to/3YWIM8h
Standless Microphone: https://amzn.to/3ZXDSci
Yeti Filter: https://amzn.to/3mZfkRF
Sony Alpha 6400L: https://amzn.to/42niFu8
Elgato Stream Deck: https://amzn.to/3Tm94Q8
Elgato Cam Link 4K: https://amzn.to/3yMOEGo
Elgato Facecam: https://amzn.to/3TqL0eX
TC Helicon Mixer: https://amzn.to/3Tmzf9p
RGB Keyboard: https://amzn.to/3JQaOOx
2k Gaming Monitor: https://amzn.to/3yNJWs2
Switch: https://amzn.to/3JQftQA
My name is Excel: I solve problems: https://amzn.to/3LxkrD4
DAX book in Italian: https://amzn.to/3TGHj4L
The Definitive Guide to DAX: https://amzn.to/3JLunYe
Prime Student 90gg free: https://amzn.to/3YWDwBm
============ R I S O R S E ===================
Channel Index - Available to subscribers only: https://docs.google.com/spreadsheets/...
Download Abb: https://drive.google.com/file/d/1OhTv...
Lesson Chapters:
00:00 Introduction
00:20 Excel Solution
01:34 PowerQuery Solution
06:19 PowerPivot CalculatedField Solution
09:01 PowerPivot Solution Measure
14:55 Greetings
#ConversionYearMonth #PowerQuery #PowerPivot