Тёмный

#infosys 

MilEstOne CrEaTor
Подписаться 38 тыс.
Просмотров 2,6 тыс.
50% 1

#powerbi #powerbi_training #powerbi_interview_Question
#scenario_based_PowerBI_Interview_Q&A #deloitte #tcs #milestonecreator
Hey, Everyone Welcome back to our Channel "Milestone Creator". In this video, I will share with you one Most Important Scenario-based Power BI interview questions that was asked in the Power BI interview at the "#infosys Technology. This question was provided to me by one of my connections on LinkedIn. So, thought of creating a video on this so that everyone can be made aware of this scenario-based question. So, let's discuss the scenario but before that, if you're new to the channel then do subscribe and hit the Bell icon to stay updated with all the coming useful videos.
🔥Scenario based Power BI Interview Q & A Playlists Link:-studio.ru-vid.comP...
🚀Pbix File:-
drive.google.com/file/d/10Osw...
✅QUESTION:-
How To Calculate Year over Year (YoY) Variance % In POWER BI ❓
✅Answer:-
🚀Calendar = CALENDARAUTO()
🚀Date = DATE(YEAR('Calendar'[Date Time]), MONTH('Calendar'[Date Time]), DAY('Calendar'[Date Time]))
🚀Total Revenue =
SUMX(Purchase, Purchase[Revenue])
🚀Previous Year Revenue = CALCULATE([Total Revenue],
DATEADD('Calendar'[Date],-1,YEAR))
🚀YoY Variance = [Total Revenue] - [Previous Year Revenue]
🚀YoY Variance % =
DIVIDE([YoY Variance],[Previous Year Revenue])
✅Related Tags:-
Real-time Power Bi Interview Questions and Answers
Power Bi interview questions
Power Bi interview questions and answers
Power Bi interview
Power Bii interview questions for experienced professionals
Power Bi interview questions for freshers
Deloitte Power Bi interview questions
Power Bi scenario-based interview questions
Power Bi service interview questions
Live Recorded Power Bi Interview Questions And Answers
#techmahindra Power Bi scenario-based interview questions
#mindtree Power Bi scenario-based interview questions
#infosys Power Bi scenario-based interview questions
#tcs Power Bi service interview questions
#deloitte Power Bi service interview questions
#pwc Power Bi service interview questions
scenario based power bi interview questions
Power Bi practice scenarios
Power Bi real-time scenarios
Power Bi scenario-based questions
sql and Power Bi interview questions
Capgemini Power Bi interview questions
Accenture Power Bi interview questions
power bi-managerial round interview questions
how to explain a project in Power Bi interview
Preselected Slicer
SQL server interview questions
Power Bi roadmap
Power BI jobs for freshers
Power BI resume for freshers
Power Bi fresher jobs
Power Bi resume
Power BI developer resume
Tips and Tricks Before POWER BI Interview
------------------------------------------------------------------------------
✅ Additional resources
------------------------------------------------------------------------------
#deloitte 📊TOP 10 Scenario Based POWER BI Interview Q And A🔥:-
• #deloitte 📊TOP 10 Scen...
#mindtree 🔥Scenario-Based Power BI Interview Q & A Based On Handling Blank Value To Zero:-
• #mindtree 🔥Scenario-Ba...
#tcs 📊TOP 10 Scenario Based #powerbi Interview Q And A🔥[ For Freshers/Experienced Candidate ]:-
• #tcs 📊TOP 10 Scenario ...
#techmahindra 🔥Scenario-Based Power BI Interview Q & A Based On Data Source Connection Change:-
• #techmahindra 🔥Scenari...
#infosys 🔥Scenario-Based Power BI Interview Q & A Based On📊Calculation Of Year Over Year (YoY %):-
• #infosys 🔥Scenario-Bas...
📊 Complete Power Bi interview Q & A For Freshers - [ Latest 2023 ]:-
• 📊 Complete Power Bi In...
DAX Interview Questions and Answers - POWER BI [ Part - 1 ]🔥:-
• DAX Interview Question...
DAX Interview Questions and Answers - POWER BI [ Part - 2 ]🔥:-
• DAX Interview Question...
Super 30 DAX Interview Question & Answer - POWER BI🔥:-
• Super 30 DAX Interview...
Introduction To DAX:-
• Introduction To DAX - ...
How To Update Your Power Bi Desktop To Latest Version || [👉In 2023 ]:- • How To Update Your Pow...
What Is DAX - Power Bi ? 📊Complete Introduction🔥:-
• What Is DAX - Power Bi...
🔔 Subscribe to my RU-vid channel:-
ru-vid.com/show-UCWfz...
Social Media Link
--------------------------------
LinkedIn:- / deepan-kumar-patel-777...
Facebook:- dipan.patel....

Опубликовано:

 

23 дек 2023

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 9   
@beneficial4u572
@beneficial4u572 6 месяцев назад
very helpfull and imp topic asked in interview. Beautifully explained. Keep posting
@dillipkumarpatel1943
@dillipkumarpatel1943 6 месяцев назад
Very good
@muhammadsabirhussain1503
@muhammadsabirhussain1503 6 месяцев назад
Thanks.
@balaroxx2700
@balaroxx2700 Месяц назад
Variance=(divide('sales'[sales amount],[prev sale])-1) Prev sale = calculate (sum(sales amount),same period last year(date.year)) Try it
@DexterDialytic9nik
@DexterDialytic9nik 6 месяцев назад
Heyyy MilEstOne, nice explanations Can you take Power BI class? I really want to learn Power BI in proper way.
@kajoripaul7279
@kajoripaul7279 12 дней назад
can u pls help me understand,could we have used sum instead of sumx..would it give same results..m just a newbie in powerbi..thanks fro your help!!
@saifulislam-xq9wh
@saifulislam-xq9wh 2 месяца назад
please provide data source
Далее
你们会选择哪一辆呢#short #angel #clown
00:20
Куда Анджилиша снова летит???
00:16
Getting Started with Calculation Groups in Power BI
23:09
Power BI Interview: Live recorded Power BI interview
34:16