Power BI DAX - SUM, SUMX & FIRSTNONBLANK - Sum of Distinct Values based on another column

This video explains - how to use SUMX and FIRSTNONBLANK with a working example and complete definition.

If you want to stay updated with more Power BI DAX videos, like this video and subscribe to this channel. Do comment your topic for which you want a video with a detailed explanation.

#datascience #datascientist #dataanalyst #dataanalytics
-----
Important timelines of the video:
00:00 - 01:10 - Problem Statement Discussion
01:11 - 01:39 - Import the Source Data
01:40 - 03:05 - Write a measure using SUMX and FIRSTNONBLANK (important step)
03-06 - 03:30 - Checking the final output
03:31 - 04:14 - SUMX vs SUM - Why SUM cannot be used?
04:15 - 08:06 - Complete explanation of FIRSTNONBLANK (with example)
08:19 - 08:46 - Problem Statement for another video
------
In the age of the digital world, data is piling up everywhere. Finding crucial insights from the dataset with respect to the business is of prime importance. It requires a combination of technical skills, analytical mindset, domain expertise, and knowledge of mathematics. On top of that, a good communicator is of prime importance.

This channel - The Career Train will bring videos related to the Data Science career. All videos are crafted from personal experience and learning - thus giving you the right view of the Data Science industry. The videos of this channel shall you with technical and professional skills with respect to the Data Science industry and related fields.

If you like this video, please hit the subscribe button of our channel, to stay updated with our upcoming videos.

Let's connect on other social media handles:

LinkedIn: https://bit.ly/317Msd0
Instagram: https://bit.ly/3fMjWld

#Python #PowerBI #tableau #data #career #job #analyst #engineering #analytics #SQL
#thecareertrain #careerontrack #machinelearning #businessanalyst #dataanalytics

Видео Power BI DAX - SUM, SUMX & FIRSTNONBLANK - Sum of Distinct Values based on another column канала Dinkar Analytics