HOW and WHEN to use Measures and Calculated Columns // Beginners Guide to Power BI in 2021

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 ก.ย. 2024
  • Get Demo Files here
    ko-fi.com/s/e4...
    In this video we go through the key differences between measures and calculated columns, looking at their definitions and best practice usage.
    -
    🚩 Support us to get perks such as demo files, early access and more!
    / solutionsabroad
    MY FAVOURITE POWER BI BOOKS
    📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
    📗 DAX Patterns - amzn.to/3oVgOYs
    MY GEAR
    🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
    💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
    🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
    💡 LED Studio Lighting - amzn.to/3q3ftQz
    🎙 Lavalier Microphone - amzn.to/3jwKutG
    📺 Monitor - amzn.to/2LuHhhO
    GET IN TOUCH
    📺 Website - www.solutionsabroad.co.uk
    📧 Email me - fernan@solutionsabroad.co.uk
    🤵 LinkedIn - / solutionsabroad
    📘 Facebook - / solutionsabroad
    📸 Instagram - / solutions_abroad
    🐤 Twitter - / abroadsolutions
    🤖 Reddit - / fernanespejo
    🌍 WHO IS SOLUTIONS ABROAD
    Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of TH-cam.
    If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
    🐎 First, watch this video about how a typical Power BI workflow looks like
    • Power BI from START to...
    🗺 Learn DAX to extend your Power BI calculations
    • Power BI DAX Basics OLD
    📆 Stay up-to-date on all the features Power BI releases monthly
    • Power BI Monthly Featu...
    🧪 Get certified as a Microsoft Data Analyst Associate
    • Power BI DA 100 Prepar...
    💡 Learn Power BI Features to improve your dashboards
    • Power BI Feature Highl...
    📊 WHAT IS POWER BI?
    Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
    🔻 Get started with Power BI Desktop for FREE
    powerbi.micros...
    #PowerBI #DataAnalytics #BusinessIntelligence

ความคิดเห็น • 17

  • @JuleeChan
    @JuleeChan 2 หลายเดือนก่อน +1

    The best explanation so far❤ thanks

  • @Littlepeanut9
    @Littlepeanut9 3 หลายเดือนก่อน

    I think you should have put this video somewhere in the beginning . It would have been easier to pay attention on what you are doing in the rest of the videos.

  • @UmaMukherjee-y4l
    @UmaMukherjee-y4l 7 หลายเดือนก่อน +1

    Can we use calculate function in calculated column

  • @josephrapp8861
    @josephrapp8861 ปีที่แล้ว +1

    Looking for the difference between the two and this gives the best explanation. Thank you!

  • @nikhilsapkale299
    @nikhilsapkale299 3 ปีที่แล้ว +2

    You share very practical power bi knowledge & experience with us. Thanks a lot.

    • @SolutionsAbroad
      @SolutionsAbroad  3 ปีที่แล้ว +1

      I appreciate your kind words Nikhil, thanks for watching!

  • @cogcog312
    @cogcog312 2 ปีที่แล้ว +2

    This is the best video I have watched so far on the difference between these two. Thanks.

  • @Odysseyofduo
    @Odysseyofduo 3 ปีที่แล้ว +1

    Hello,
    I'm looking for power bi training, do you provide any?

    • @SolutionsAbroad
      @SolutionsAbroad  3 ปีที่แล้ว

      Hi thanks for enquiring, I'll be releasing some Power BI Training Courses in the near future if it will help!

  • @mahmoudhassan6627
    @mahmoudhassan6627 ปีที่แล้ว

    Wonderful wonderful wonderful ...
    You are the best Sir . Your follower " Mahmoud Hassan " from Tripoli - Libya ...
    Thank you very much for those valuable lessons.
    I owe you very much ...

  • @sundaynyanabo2777
    @sundaynyanabo2777 6 หลายเดือนก่อน

    Each time I watch any of your videos, there is something new I learn. Keep this up broh. Regards.

  • @alisonhenley2551
    @alisonhenley2551 ปีที่แล้ว

    Very very good explanation. I really enjoy the examples you share, super straightforward. THANK YOU!

  • @lijunchen
    @lijunchen ปีที่แล้ว

    This is very informative. But I still have some questions. One is why the measure created must use the SUMX function? Can we just use the results of the product (*)? The other question is: why should we use the calculated column instead of just adding a new column to the data table in the query (using M language). We can use that column as a slicer too.

  • @DeeptiDubey1380
    @DeeptiDubey1380 ปีที่แล้ว

    thank you so much for making Dax easier for us.👍🏿👍🏿

  • @multitaskprueba1
    @multitaskprueba1 ปีที่แล้ว

    Fantastic video! Thank you!

  • @SandipanSarkar-c8v
    @SandipanSarkar-c8v 8 หลายเดือนก่อน

    Finished watching