Power BI DAX Tutorial (2/50) - What is Measure or Calculated Column
ฝัง
- เผยแพร่เมื่อ 22 มิ.ย. 2020
- 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/shop/analyticsw...
✉ Business Queries / Analytics Consulting ✉ : analyticswithnags@gmail.com
💬 For Learners Post queries and Interact 💬 : t.me/analyticswithnags
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... - วิทยาศาสตร์และเทคโนโลยี
Thank You Nags, Excellent explanation ... looking forward to DAX Vidos from 40 - 50...Thank you for creating this great channel
Soon will create
its took deep 20 min to understand the previous year sales formula :) Thank god :):)
Glad you understand it
Very Excellant Explanation......great job ..keep continue
Most welcome, Keep Learning
That was very smooth explanation thank you bro.
Thanks for your comments.
Keep learning
Share this channel with your friends and colleagues
Sir can we get this data for practice..this is very nice TH-cam channel
Your explanation is very good.
Thanks and welcome
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.
Noted
You are brilliant , Sir 🙂
Thanks keep learning share this channel with friends and colleagues
It is same as group by and windows function in SQL
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.
Not sure about question.
Good Explanation🍓
Thanks for liking, Keep Learning
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
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
very useful
Glad to hear that
Thanks for the videos ...can you please share dataset for practise
Check the description of the video. If it does not exist check the previous video in the playlist
It was Good 👌👌
Welcome
hi sir so which is best to use calculated colum are mesure
Watch this again. I already answered. There is no best concept here. You have to choose based on the purpose.
is it possible that sameperiodlastyear function to do in calculated column?
Try it
Hi Nag. Can I get the dataset for practice..Thanks in advance
Check in desc, mostly it's there . if not available it should be simple so prepare the data yourself.
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
.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.
@@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.
i faced the same issue.
Superb 👌
Thanks keep learning
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 😉
Will try to cover and improve it
where is dataset has used in your video. from where i download same dataset
Video is for understanding.
Where can we get datasets used in the videos ?
Check the description if not exist use the file from previous videos in the respective playlist
Hi Sir, I tried to create the measure using sameperiodlastyear. But the sameperiodlastyear forumla shows error in the measure. Please clarified my doubt.
Watch again. Ensure you use the proper date column
@@AnalyticswithNags Tnq sir i got it. The same process done two times but i do not get the result first time.
Hi when I drop sales date in the table,in the drop down it not showing me year, month,day
Not sure what you want to acheive
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
In direct query, measure and calculate column is possible. In live connection only calculated column
Unable to add new measure in xaxis in clustered bar chart ,how can this be resolved..please reply
Not sure what are you doing
Hi Sir , from where to download naga garment excel sheet?
Check the description
Where is the link of the database file and final output? How can we download it?
No
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.
Check this video th-cam.com/video/PP23ws8H0XE/w-d-xo.html
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 .
@@AnalyticswithNagsafter watching the pinned video error resolved. Thank you sir.
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...
Watch video again
Thanku sir
I am getting blank values for previous year , I only see the total but month-wise its blank
I hope you seeing the earliest year-month for that it will be blank. Check the latest year month combination.
Hello
Sir the rest of videos from 39 to 50 have not uploaded
Will u upload?
Thanks
Remaining videos are planned videos. We will upload once it is ready
Tnx
dear sir , Can you pls give us complete list of formulas
Check the DAX playlist
Bro do video on how to use dax studio
Will make it soon
HI, I write a query below, but it return same year results. CALCULATE(sum(financials[Profit]),SAMEPERIODLASTYEAR(financials[Date].[Date]))
May be you have same data last year and current year. Your formula is correct
how to calculate same period last year growth percentage
Watch the parallel period or same period last year video
Hi sir,
I have a doubt with previous years sales formula. How will current year sales comes more than total sales ...?
Depends on running data
Need more example with more details on formulas.
How to write the formula for other functions
check the dax playlist of the channel page for more videos.
Check out the April month data ... Previous year sales is more than total sales ... How it comes ??
Total sales is 3166850 and for april month 517250. How's it same?
Will check
CAN I GET THE DATASET
we dont maintain excel , prepare your own file like the one shown , with your own sample data.
Can you please provide us PPT ?
No. But can you tell me why you need that
@@AnalyticswithNags to make notes or to study/revision step by step..
dataset?
Practice with own dataset
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
Use parallel period function
Please, let captions unblocked
Sure
If it is is Hindi language, would be better understand.
We don't do Hindi lang at this moment, you can refer to some other channel which has hindi content on these.
No clear
Watch again
bro videos r good,
but u appear tired/little disinterested in ur videos....
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