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

Sdílet
Vložit
  • čas přidán 22. 06. 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...
  • Věda a technologie

Komentáře • 105

  • @irfandaud7380
    @irfandaud7380 Před 2 lety +2

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

  • @SairamV17
    @SairamV17 Před 2 lety +1

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

  • @VarunKumar-xt4jq
    @VarunKumar-xt4jq Před 6 měsíci +1

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

  • @sidindian1982
    @sidindian1982 Před rokem +1

    You are brilliant , Sir 🙂

    • @AnalyticswithNags
      @AnalyticswithNags  Před rokem

      Thanks keep learning share this channel with friends and colleagues

  • @Tahsina_22
    @Tahsina_22 Před 3 lety +1

    Your explanation is very good.

  • @kedarpande
    @kedarpande Před 2 lety +1

    Good Explanation🍓

  • @kalyankothapalli1845
    @kalyankothapalli1845 Před 3 lety +1

    That was very smooth explanation thank you bro.

    • @AnalyticswithNags
      @AnalyticswithNags  Před 3 lety

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

    • @suribhandari1985
      @suribhandari1985 Před 3 lety

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

  • @reshmatube1715
    @reshmatube1715 Před 2 lety +1

    Superb 👌

  • @vivekjasrotia7247
    @vivekjasrotia7247 Před rokem +1

    It was Good 👌👌

  • @ranjeeta6231
    @ranjeeta6231 Před 2 měsíci +1

    It is same as group by and windows function in SQL

  • @arunsundarm4566
    @arunsundarm4566 Před 11 měsíci +1

    very useful

  • @mhn9314
    @mhn9314 Před rokem +2

    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.

  • @tejaswipalla8824
    @tejaswipalla8824 Před 2 lety +1

    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.

  • @bhavanit56
    @bhavanit56 Před rokem +1

    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
      @AnalyticswithNags  Před rokem

      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

  • @saikiran9185
    @saikiran9185 Před 2 lety

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

  • @VimalKumar-kz6yg
    @VimalKumar-kz6yg Před 2 lety +1

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

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

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

  • @samuelgidaygoodday2036
    @samuelgidaygoodday2036 Před 2 lety +4

    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 😉

  • @babutechnicall7988
    @babutechnicall7988 Před 3 lety +1

    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
      @AnalyticswithNags  Před 3 lety +1

      .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
      @amirtamboli938 Před 3 lety

      @@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
      @tejaswipalla8824 Před 2 lety

      i faced the same issue.

  • @hemangrathore4734
    @hemangrathore4734 Před 2 lety +1

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

  • @rasikadeshmukh3601
    @rasikadeshmukh3601 Před 2 lety +2

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

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

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

  • @FirozKhan-vi7tn
    @FirozKhan-vi7tn Před rokem +1

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

  • @saurabhjaiswal6506
    @saurabhjaiswal6506 Před 2 lety

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

  • @sandhyapenmetsa7345
    @sandhyapenmetsa7345 Před 2 lety +1

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

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

      Watch again. Ensure you use the proper date column

    • @sandhyapenmetsa7345
      @sandhyapenmetsa7345 Před 2 lety

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

  • @shahinashaik7394
    @shahinashaik7394 Před 3 lety +1

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

    • @AnalyticswithNags
      @AnalyticswithNags  Před 3 lety

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

  • @iamnishant26
    @iamnishant26 Před 2 lety +1

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

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

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

  • @debduttaroy3414
    @debduttaroy3414 Před 2 lety +1

    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
      @AnalyticswithNags  Před 2 lety

      Check this video czcams.com/video/PP23ws8H0XE/video.html

    • @mohammadfazil5419
      @mohammadfazil5419 Před 10 měsíci

      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
      @mohammadfazil5419 Před 10 měsíci

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

  • @harshalpatel860
    @harshalpatel860 Před 2 lety +1

    Where can we get datasets used in the videos ?

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety +1

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

  • @VikasNegivn
    @VikasNegivn Před 2 lety +1

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

  • @debduttaroy3414
    @debduttaroy3414 Před 2 lety +1

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

  • @reddemmag8590
    @reddemmag8590 Před měsícem

    can you please share dataset for this tutorial

  • @siddheshdandagavhal9804

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

  • @NothingSpecial-_-
    @NothingSpecial-_- Před 2 lety +1

    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
      @AnalyticswithNags  Před 2 lety +1

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

  • @adventuresofvyomandkeshav3036

    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...

  • @abcdefghijn5005
    @abcdefghijn5005 Před 2 lety +1

    Bro do video on how to use dax studio

  • @chandrashekharmuktapur5585

    how to calculate same period last year growth percentage

  • @RamKi_92
    @RamKi_92 Před 3 lety

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

  • @ismailabid8178
    @ismailabid8178 Před 2 lety +1

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

  • @gvinod4448
    @gvinod4448 Před 2 lety

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

  • @ashwinizare7183
    @ashwinizare7183 Před 3 lety

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

  • @srinivasanramachandran4867

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

    • @AnalyticswithNags
      @AnalyticswithNags  Před 4 lety

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

  • @RamKi_92
    @RamKi_92 Před 3 lety

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

  • @jayantdalvi
    @jayantdalvi Před 11 měsíci

    CAN I GET THE DATASET

    • @AnalyticswithNags
      @AnalyticswithNags  Před 9 měsíci

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

  • @prateekchoudhary1717
    @prateekchoudhary1717 Před 3 lety +1

    Can you please provide us PPT ?

  • @shirfilmohammed3191
    @shirfilmohammed3191 Před rokem +1

    dataset?

  • @esmeiquer1585
    @esmeiquer1585 Před 3 měsíci

    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

  • @andersonaraujo1992
    @andersonaraujo1992 Před rokem +1

    Please, let captions unblocked

  • @urband554
    @urband554 Před rokem +1

    No clear

  • @ashwinizare7183
    @ashwinizare7183 Před 3 lety

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

    • @AnalyticswithNags
      @AnalyticswithNags  Před 3 lety

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

  • @AnandKumar-dc2bf
    @AnandKumar-dc2bf Před 3 lety +2

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

    • @AnalyticswithNags
      @AnalyticswithNags  Před 3 lety +2

      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