PBI - Percentage Calculation
In this video we will explore the correct way to calculate percentages in the PowerBi and/or Excel data model, generally the 2 formulas are these: (CY-PY)/PY or CY/PY-1, we could have unexpected results if we use the wrong formula or we write it incorrectly in DAX, in this video we will delve into the different types of results.
=========== 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 EQUIPMENT ===============
Mouse: https://amzn.to/3Tnu1Kk
Yeti Microphone: https://amzn.to/3YWIM8h
Boomless 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 90 days free: https://amzn.to/3YWDwBm
============ R I S O R S E =======
Channel Index - Available to subscribers only: https://docs.google.com/spreadsheets/...
DOWNLOAD subscribers: https://drive.google.com/file/d/1a6R3...
Lesson Chapters:
00:00:00 Introduction
00:02:25 CY/PY-1 Errata_1
00:03:28 Divide(CY,PY)-1 Errata_2
00:04:14 (CY-PY)/PY Errata_3
00:04:38 Divide(CY-PY,PY) Correct
00:05:35 Divide(CY-PY,PY,1 or 0) Correct
00:07:00 Additional considerations
00:09:36 Greetings
#PercentageCalculator #DAXPercentage #PowerBI