Power BI DAX Tutorial (2/50) - What is Measure or Calculated Column

No video

Power BI DAX Tutorial (2/50) - What is Measure or Calculated Column

Рет қаралды 113,066

Күн бұрын

When to use Measure / Calculated Column in Power BI, How measure is calculated on runtime, What is Measure and calculated column in Power BI, How to create a Simple Measure in Power BI, How to create a Simple Calculated column in Power BI, Basics of DAX , Power BI DAX Tutorial with Examples
#powerbi #powerbidax #daxmeasure
🏬 Visit our Amazon Influencer Store 🏬 : www.amazon.in/...
✉ Business Queries / Analytics Consulting ✉ : analyticswithnags@gmail.com
💬 For Learners Post queries and Interact 💬 : t.me/analyticsw...
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Power Pivot 📚📖 • Power BI Tutorial (15/...
Power Query 📚📖 • Power BI Tutorial (15/...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Tamil Tutorials 📚📖 • How to do Power BI Ins...
Power BI Telugu Tutorials 📚📖 • How to do Power BI Ins...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
MSBI Tutorials - SQL + SSAS + SSIS 📚📖 • Learn SQL Complete | C...
Data Analyst - Complete Reference - Playlist 📚📖 • Data Analytics For Beg...
BI Developer - Complete Reference - Playlist
📚📖 • Power BI Tutorial From...
BI Architect - Complete Reference - Playlist
📚📖 • Power BI Full Course -...
ETL Developer - Complete Reference - Playlist 📚📖 • Building an Enterprise...
Database Developer - Complete Reference - Playlist 📚📖 • SQL Tutorial - Full Da...

Пікірлер: 106

@SairamV17 2 жыл бұрын

its took deep 20 min to understand the previous year sales formula :) Thank god :):)

@AnalyticswithNags 2 жыл бұрын

Glad you understand it

@irfandaud7380 2 жыл бұрын

Thank You Nags, Excellent explanation ... looking forward to DAX Vidos from 40 - 50...Thank you for creating this great channel

@AnalyticswithNags 2 жыл бұрын

Soon will create

@lekkalasreenu2539 13 күн бұрын

Good teaching sir

@mhn9314 Жыл бұрын

Very well explained, Sir. However, would request you to provide datasets with us so that as beginners, we can practice with the same eg. that you've used for demonstration.

@AnalyticswithNags Жыл бұрын

Noted

@samuelgidaygoodday2036 2 жыл бұрын

I wish you spent extra 30 seconds explaining what the functions do at least to the point of what values they take - Thanks for sharing and caring 😉

@AnalyticswithNags 2 жыл бұрын

Will try to cover and improve it

@VarunKumar-xt4jq 7 ай бұрын

Very Excellant Explanation......great job ..keep continue

@AnalyticswithNags 6 ай бұрын

Most welcome, Keep Learning

@ranjeeta6231 3 ай бұрын

It is same as group by and windows function in SQL

@Tahsina_22 3 жыл бұрын

Your explanation is very good.

@AnalyticswithNags 3 жыл бұрын

Thanks and welcome

@rasikadeshmukh3601 2 жыл бұрын

Thanks for the videos ...can you please share dataset for practise

@AnalyticswithNags 2 жыл бұрын

Check the description of the video. If it does not exist check the previous video in the playlist

@sidindian1982 Жыл бұрын

You are brilliant , Sir 🙂

@AnalyticswithNags Жыл бұрын

Thanks keep learning share this channel with friends and colleagues

@kalyankothapalli1845 3 жыл бұрын

That was very smooth explanation thank you bro.

@AnalyticswithNags 3 жыл бұрын

Thanks for your comments. Keep learning Share this channel with your friends and colleagues

@suribhandari1985 3 жыл бұрын

Sir can we get this data for practice..this is very nice KZfaq channel

@bhavanit56 Жыл бұрын

Sir i have one doubt let us consider our table has 2 sales value for same catagory. lets say watches if I put the category in table if I don't apply measure then what would be sales still it will sum up 2 values in table or it will pick up value of first watches row

@AnalyticswithNags Жыл бұрын

If you don’t use measure then it will show only distinct values of category. If you use measure then it is sim up and show the value

@NothingSpecial-_- 2 жыл бұрын

Sir, I have an important question - Can we create Calculated Columns, Calculated Measures or Calculated Tables with Direct Query or Live Connection? Please answer.. Thank you

@AnalyticswithNags 2 жыл бұрын

In direct query, measure and calculate column is possible. In live connection only calculated column

@reddemmag8590 Ай бұрын

can you please share dataset for this tutorial

@FirozKhan-vi7tn Жыл бұрын

where is dataset has used in your video. from where i download same dataset

@AnalyticswithNags Жыл бұрын

Video is for understanding.

@kedarpande 2 жыл бұрын

Good Explanation🍓

@AnalyticswithNags 2 жыл бұрын

Thanks for liking, Keep Learning

@VimalKumar-kz6yg 2 жыл бұрын

hi sir so which is best to use calculated colum are mesure

@AnalyticswithNags 2 жыл бұрын

Watch this again. I already answered. There is no best concept here. You have to choose based on the purpose.

@hemangrathore4734 2 жыл бұрын

Hi when I drop sales date in the table,in the drop down it not showing me year, month,day

@AnalyticswithNags 2 жыл бұрын

Not sure what you want to acheive

@vivekjasrotia7247 Жыл бұрын

It was Good 👌👌

@AnalyticswithNags Жыл бұрын

Welcome

@arunsundarm4566 Жыл бұрын

very useful

@AnalyticswithNags 10 ай бұрын

Glad to hear that

@ismailabid8178 2 жыл бұрын

Hello Sir the rest of videos from 39 to 50 have not uploaded Will u upload? Thanks

@AnalyticswithNags 2 жыл бұрын

Remaining videos are planned videos. We will upload once it is ready

@ismailabid8178 2 жыл бұрын

Tnx

@harshalpatel860 2 жыл бұрын

Where can we get datasets used in the videos ?

@AnalyticswithNags 2 жыл бұрын

Check the description if not exist use the file from previous videos in the respective playlist

@tejaswipalla8824 2 жыл бұрын

Hi Sir, I tried to create the measure using sameperiodlastyear. when I created a tabular visual i couldn't see the previous year values to compare with current year. but i can see the sum correctly for both measures .what could be problem that previous year values are not visible.

@AnalyticswithNags 2 жыл бұрын

Not sure about question.

@reshmatube1715 2 жыл бұрын

Superb 👌

@AnalyticswithNags 2 жыл бұрын

Thanks keep learning

@VikasNegivn 2 жыл бұрын

Where is the link of the database file and final output? How can we download it?

@AnalyticswithNags 2 жыл бұрын

@sandhyapenmetsa7345 2 жыл бұрын

Hi Sir, I tried to create the measure using sameperiodlastyear. But the sameperiodlastyear forumla shows error in the measure. Please clarified my doubt.

@AnalyticswithNags 2 жыл бұрын

Watch again. Ensure you use the proper date column

@sandhyapenmetsa7345 2 жыл бұрын

@@AnalyticswithNags Tnq sir i got it. The same process done two times but i do not get the result first time.

@abcdefghijn5005 2 жыл бұрын

Bro do video on how to use dax studio

@AnalyticswithNags 2 жыл бұрын

Will make it soon

@debduttaroy3414 2 жыл бұрын

Hi Sir , from where to download naga garment excel sheet?

@AnalyticswithNags 2 жыл бұрын

Check the description

@shahinashaik7394 3 жыл бұрын

Hi Nag. Can I get the dataset for practice..Thanks in advance

@AnalyticswithNags 3 жыл бұрын

Check in desc, mostly it's there . if not available it should be simple so prepare the data yourself.

@iamnishant26 2 жыл бұрын

I am getting blank values for previous year , I only see the total but month-wise its blank

@AnalyticswithNags 2 жыл бұрын

I hope you seeing the earliest year-month for that it will be blank. Check the latest year month combination.

@adventuresofvyomandkeshav3036 2 жыл бұрын

Sir first I create a column salesrevenue=sales*quantity Then I create a measure Salesrevenuemes=sum(order[sales])*sum(order[quantity]) but got different values...

@AnalyticswithNags 2 жыл бұрын

Watch video again

@adventuresofvyomandkeshav3036 2 жыл бұрын

Thanku sir

@debduttaroy3414 2 жыл бұрын

Sir, sameperiodlastyear is not working for me .. It is Prev year sales = CALCULATE(sum([Sales Amount]),SAMEPERIODLASTYEAR(Data[Sale date])) coming in my power BI desktop . ".date" is not coming and showing error.

@AnalyticswithNags 2 жыл бұрын

Check this video kzfaq.info/get/bejne/hrZiZtqkna6UiHk.html

@mohammadfazil5419 11 ай бұрын

Facing same issue after creating date table in ADVANCED EDITOR. After creating date table not able to add .DATE after sale date. It shows syntax for 'DATE' is incorrect. Kindly explain this .

@mohammadfazil5419 11 ай бұрын

@@AnalyticswithNagsafter watching the pinned video error resolved. Thank you sir.

@chandrashekharmuktapur5585 2 жыл бұрын

how to calculate same period last year growth percentage

@AnalyticswithNags 2 жыл бұрын

Watch the parallel period or same period last year video

@babutechnicall7988 3 жыл бұрын

Hello Nag, i have tried to analyze last year data with current year data just like you shown.. here i tried to convert the sale date column as date data type and not used [sale date].[date] i have used [sale date] directly in the sameperiodlastyear function.. it is not showing any data in the lastyear column of the table visual.. later i used [sale date].[date] as you shown then it worked.. why should we use this .[date] even the type of data is date? kindly provide your inputs. Thanks, babu

@AnalyticswithNags 3 жыл бұрын

.Date should be used when you refer a date column (which will create a small table for each date column) so you need to refer .Date to refer a date column.

@amirtamboli938 3 жыл бұрын

@@AnalyticswithNags Sir, Year Sales Qty = CALCULATE(SUM(FactSecondarySales[Sale Qty]), SAMEPERIODLASTYEAR(FactSecondarySales[Sale Date].[Date])) I am not able to add .[Date] after [Sale Date] what problem should be there. Need your help. Thank you.

@tejaswipalla8824 2 жыл бұрын

i faced the same issue.

@saurabhjaiswal6506 2 жыл бұрын

Unable to add new measure in xaxis in clustered bar chart ,how can this be resolved..please reply

@AnalyticswithNags 2 жыл бұрын

Not sure what are you doing

@siddheshdandagavhal9804 Ай бұрын

Prev Year Sale = Calculate(Sum([Sales Amount], SAMEPERIODLASTYEAR('SALE'[Date]))

@ashwinizare7183 3 жыл бұрын

Need more example with more details on formulas. How to write the formula for other functions

@AnalyticswithNags 3 жыл бұрын

check the dax playlist of the channel page for more videos.

@saikiran9185 2 жыл бұрын

is it possible that sameperiodlastyear function to do in calculated column?

@AnalyticswithNags 2 жыл бұрын

Try it

@srinivasanramachandran4867 4 жыл бұрын

HI, I write a query below, but it return same year results. CALCULATE(sum(financials[Profit]),SAMEPERIODLASTYEAR(financials[Date].[Date]))

@AnalyticswithNags 4 жыл бұрын

May be you have same data last year and current year. Your formula is correct

@shirfilmohammed3191 Жыл бұрын

dataset?

@AnalyticswithNags Жыл бұрын

Practice with own dataset

@jayantdalvi Жыл бұрын

CAN I GET THE DATASET

@AnalyticswithNags 10 ай бұрын

we dont maintain excel , prepare your own file like the one shown , with your own sample data.

@gvinod4448 2 жыл бұрын

dear sir , Can you pls give us complete list of formulas

@AnalyticswithNags 2 жыл бұрын

Check the DAX playlist

@RamKi_92 3 жыл бұрын

Check out the April month data ... Previous year sales is more than total sales ... How it comes ??

@surajkashyap067 3 жыл бұрын

Total sales is 3166850 and for april month 517250. How's it same?

@AnalyticswithNags 3 жыл бұрын

Will check

@andersonaraujo1992 Жыл бұрын

Please, let captions unblocked

@AnalyticswithNags Жыл бұрын

Sure

@RamKi_92 3 жыл бұрын

Hi sir, I have a doubt with previous years sales formula. How will current year sales comes more than total sales ...?

@AnalyticswithNags 3 жыл бұрын

Depends on running data

@prateekchoudhary1717 3 жыл бұрын

Can you please provide us PPT ?

@AnalyticswithNags 3 жыл бұрын

No. But can you tell me why you need that

@prateekchoudhary1717 3 жыл бұрын

@@AnalyticswithNags to make notes or to study/revision step by step..

@esmeiquer1585 4 ай бұрын

what if you want to show the preview of the last 5 years in a bar chart. sameperiodlast2years sameperiodlast3years ... kinda funny in that way. How to do this without using this function sameperiodlastyear

@AnalyticswithNags 4 ай бұрын

Use parallel period function

@urband554 Жыл бұрын

No clear

@AnalyticswithNags Жыл бұрын

Watch again

@ashwinizare7183 3 жыл бұрын

If it is is Hindi language, would be better understand.

@AnalyticswithNags 3 жыл бұрын

We don't do Hindi lang at this moment, you can refer to some other channel which has hindi content on these.

@AnandKumar-dc2bf 3 жыл бұрын

bro videos r good, but u appear tired/little disinterested in ur videos....

@AnalyticswithNags 3 жыл бұрын

I can't agree with disinterested. Since it's my passion to teach people with my full interest. I can agree I will be tired, since after working hours I need to prepare and record the videos during late night or early in the morning. Some times you can feel my voice is low or not that energetic, which doesn't meant I am not interested. We put lot of efforts to bring this content, which should reach people who really interested to learn. I hope we already satisfied those real learners