HOGOLYTICS
HOGOLYTICS
  • Видео 70
  • Просмотров 180 111
Top 10 Power BI DAX Interview Questions For Data Analysts - Part 2
Top 10 Power BI DAX Interview Questions For Data Analysts - Part 2
Do you have an interview about Power BI and worry about DAX questions? This video helps you to cover the most common questions.
Act like a pro!
I'm Shahab Hoghooghi and in this channel you will find Excel & Power BI Tutorials for Beginners to Advanced.You will find different trainings on Excel Tips and Tricks, Power BI desktop, Power BI service, DAX, Power Query, analytics, and dynamic reports
You can find more business intelligence tutorials blow:
Please read articles on: www.hogolytics.com
Follow me on LinkedIn: www.LinkedIn.com/in/sh-hogo
Follow me on Instagram: dr.shahab.hoghooghi
#dataanalytics #powerbi #dimdate...
Просмотров: 165

Видео

Top 10 Power BI DAX Interview Questions For Data Analysts - Part 1
Просмотров 1803 месяца назад
Top 10 Power BI DAX Interview Questions For Data Analysts - Part 1 Do you have an interview about Power BI and worry about DAX questions? This video helps you to cover the most common questions. Act like a pro! I'm Shahab Hoghooghi and in this channel you will find Excel & Power BI Tutorials for Beginners to Advanced.You will find different trainings on Excel Tips and Tricks, Power BI desktop, ...
Dashboard Design Best Practices - Dos and Don'ts!
Просмотров 1593 месяца назад
Dashboard Design Best Practices - Dos and Don'ts! This presentation provides you the fundamental knowledge about dashboard design. Watch this video to learn everything step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will find Excel & Power BI Tutorials for Beginners to Advanced.You will find different trainings on Excel Tips and Tricks, Power BI desktop, Power BI serv...
Top 5 DAX Functions that you have to know!!
Просмотров 3086 месяцев назад
Top 5 DAX Functions that you have to know!! Do you like to learn Power BI? These 5 functions are essentials for all Power BI developers. Watch this video to learn everything step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will find Excel & Power BI Tutorials for Beginners to Advanced.You will find different trainings on Excel Tips and Tricks, Power BI desktop, Power B...
How to Look up a value in Excel? use VLOOKUP & HLOOKUP
Просмотров 817 месяцев назад
How to Look up a value in Excel? use VLOOKUP & HLOOKUP Unlock the power of Excel with our comprehensive tutorial on VLOOKUP and HLOOKUP functions! Learn how to efficiently search for and retrieve data within your spreadsheets, whether you're working with vertical or horizontal data structures. Master these essential Excel tools to save time and streamline your data analysis workflows. Watch our...
How to use Inactive relationship in measures? USERELATIONSHIP is the function you need!
Просмотров 2197 месяцев назад
How to use Inactive relationship in measures? USERELATIONSHIP is the function you need! Have you ever tried to use different calculations based on two different relationships between two tables? You need to know how to make a disabled relationship active! Watch this video to learn everything step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will learn Power BI Tutorial ...
Excel Referencing: Absolute, Relative or Mixed?
Просмотров 827 месяцев назад
Excel Referencing: Absolute, Relative or Mixed? Understand the importance of referencing cells accurately in Excel formulas. If your formulas aren't functioning properly when copied to other cells, chances are there's an error in your cell referencing. Different cell references require varying degrees of fixing-some need to be fully fixed while others partially. This distinction is known as abs...
How to Calculate Year To Date & Financial Year To Date?
Просмотров 3417 месяцев назад
How to Calculate Year To Date & Financial Year To Date? Calculating YTD and FYTD are one of the fundamentals that all analysts need to apply in their report. Watch this video to learn how you can easily use it. Learn everything you need step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will learn Power BI Tutorial for Beginners to Advanced.You will find different traini...
Everything about New Button Slicer - Part 2
Просмотров 1067 месяцев назад
Everything about New Button Slicer - Part 1 How to use New Button Slicer like web designs. Learn everything you need step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will learn Power BI Tutorial for Beginners to Advanced.You will find different training on Power BI desktop, Power BI service, DAX, Power Query, analytics, and dynamic reports You can find more business in...
Everything about New Button Slicer - Part 1
Просмотров 1,1 тыс.8 месяцев назад
Everything about New Button Slicer - Part 1 How to use New Button Slicer like web designs. Learn everything you need step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will learn Power BI Tutorial for Beginners to Advanced.You will find different training on Power BI desktop, Power BI service, DAX, Power Query, analytics, and dynamic reports You can find more business in...
How to Replace BLANK values in Power BI?
Просмотров 2,3 тыс.11 месяцев назад
How to Replace BLANK values in Power BI? You can easily replace blankd values with any other values like zero "0" or Unknown. Learn everything you need step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will learn Power BI Tutorial for Beginners to Advanced.You will find different training on Power BI desktop, Power BI service, DAX, Power Query, analytics, and dynamic re...
How to Organize measures and Columns in Power BI? Create Folders and Subfolders!
Просмотров 882Год назад
How to Organize measures and Columns in Power BI? Create Folders and Subfolders. You can easily create folders and subfolders within your dataset and organize all your measures and columns. Learn everything you need step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will learn Power BI Tutorial for Beginners to Advanced.You will find different training on Power BI deskto...
How to Create a Column From Examples without M Power Query?
Просмотров 160Год назад
How to Create a Column From Examples without M Power Query? You can easily use a few examples to handle it. Follow the process and make your report professional. Learn everything you need step by step! Act like a pro! I'm Shahab Hoghooghi and in this channel you will learn Power BI Tutorial for Beginners to Advanced.You will find different training on Power BI desktop, Power BI service, DAX, Po...
How to use ChatGPT to create a Dim Date (Calendar) Table using DAX in Power BI?
Просмотров 171Год назад
How to use ChatGPT to create a Dim Date (Calendar) Table using DAX in Power BI? ChatGPT is an AI tool that supports you to create DAX tables without any effort. In this video you will learn how resolve the probable issues. Follow the process and make your report professional. Learn everything you need step by step! Act like a pro! In this channel you will learn Power BI Tutorial for Beginners t...
How to create Dim Date (Calendar) Table using DAX in Power BI?
Просмотров 2,4 тыс.Год назад
How to create Dim Date (Calendar) Table using DAX in Power BI? Follow the process and make your report professional. Learn everything you need step by step! Act like a pro! In this channel you will learn Power BI Tutorial for Beginners to Advanced.You will find different training on Power BI desktop, Power BI service, DAX, Power Query, analytics, and dynamic reports You can find more business i...
How to Get Monthly Data From SharePoint Folder into Power BI?
Просмотров 899Год назад
How to Get Monthly Data From SharePoint Folder into Power BI?
How to Unpivot Tables in Power BI?
Просмотров 578Год назад
How to Unpivot Tables in Power BI?
AUTOMATE your Monthly Data in Power BI - Get Data From Folder
Просмотров 1,7 тыс.Год назад
AUTOMATE your Monthly Data in Power BI - Get Data From Folder
How to refresh Power BI Dataset Incrementally? Incremental Refresh helps you to improve performance!
Просмотров 941Год назад
How to refresh Power BI Dataset Incrementally? Incremental Refresh helps you to improve performance!
How to Use Valid Date Range Slicer and Remove Extra Date in Power BI?
Просмотров 1,5 тыс.Год назад
How to Use Valid Date Range Slicer and Remove Extra Date in Power BI?
How to Send Dynamic Email to users in Power BI table?
Просмотров 3,6 тыс.Год назад
How to Send Dynamic Email to users in Power BI table?
Your Flows Fail? Change Power Automate Settings in Power BI?
Просмотров 733Год назад
Your Flows Fail? Change Power Automate Settings in Power BI?
How to Send Power BI table data as CSV file to Email? Use Power Automate!
Просмотров 26 тыс.Год назад
How to Send Power BI table data as CSV file to Email? Use Power Automate!
Learn Power BI in just 15 Minutes!
Просмотров 1,3 тыс.Год назад
Learn Power BI in just 15 Minutes!
How to Create a Native Toggle button?
Просмотров 400Год назад
How to Create a Native Toggle button?
پادکست دیتامن - قسمت سوم - آشنایی با SQL
Просмотров 107Год назад
پادکست دیتامن - قسمت سوم - آشنایی با SQL
How to Change Power BI Theme Color in Less than 10 Seconds!
Просмотров 2,6 тыс.Год назад
How to Change Power BI Theme Color in Less than 10 Seconds!
How to solve Query folding Issue for Data coming from AWS Athena through ODBC connection?
Просмотров 679Год назад
How to solve Query folding Issue for Data coming from AWS Athena through ODBC connection?
پادکست دیتامن - قسمت دوم - مهمان برنامه: وحید دوستی مجد
Просмотров 214Год назад
پادکست دیتامن - قسمت دوم - مهمان برنامه: وحید دوستی مجد
How to create a SLICER PANE?
Просмотров 452Год назад
How to create a SLICER PANE?

Комментарии

  • @berger15
    @berger15 18 дней назад

    Okay - you made this so much simpler than anyone else I've looked at! Amazing job - thank you so much. Favourited and subscribed :D

  • @angelmoreira807
    @angelmoreira807 25 дней назад

    Is there a way to avoid pressing reload this page?

  • @asirintisar7663
    @asirintisar7663 Месяц назад

    Thanks for making such video. It helped me a lot. This is one of the most effective use-case of Power Automate.

  • @UPHARANAND
    @UPHARANAND Месяц назад

    We have multiple ways to refresh a report. My question is , which refresh is fast

  • @nithishmathan4521
    @nithishmathan4521 Месяц назад

    a power bi dashboard with 2 table visuals, now i would like to sent the 2 tables as excel sheets in single excel csv file through outbox using power automate. is it possible?

    • @hogolytics
      @hogolytics Месяц назад

      You need to add another steps the same as the first table for the next ones, before the last step sending to email.

  • @sureshatla9735
    @sureshatla9735 Месяц назад

    .JSON extension theme not working when apply theme in power bi can you provide steps

  • @ianboothman540
    @ianboothman540 Месяц назад

    Great video. I have an error on send to email (v2) Input parameter email message/to is required to be of type string/email

  • @zhengcao6529
    @zhengcao6529 2 месяца назад

    You need add one more day in Duration: Duration.Days(End_of_Year - Start_Date) + 1, or you are one day less in the end, missing 12/31. Am I right?

  • @zohra1047
    @zohra1047 2 месяца назад

    Great!

  • @rachellozano6648
    @rachellozano6648 2 месяца назад

    Hi Do you have an example extracting in excel?

  • @adityarathod5649
    @adityarathod5649 2 месяца назад

    You are awsome.. I have been trying since a while but it didn't worked...and by your videos I have created these buttons thank you

  • @cofelipe6
    @cofelipe6 2 месяца назад

    Works very fine here, thank you bro!

  • @Tammy-o9q
    @Tammy-o9q 2 месяца назад

    Hello, thank you for uploading the video, it was extremely helpful. could you please send me a link for the additional columns in the dim date table?

  • @kieranburloo
    @kieranburloo 2 месяца назад

    Great video - works perfectly for me but finding the PA won't run for others?

  • @DiariesOfBen
    @DiariesOfBen 2 месяца назад

    Thanks for the tutorial, but is it possible to send a visualized table to email without the button so it's automatically sent to specific emails?

  • @saharkouroshnezhad4845
    @saharkouroshnezhad4845 3 месяца назад

    Thanks Shahab, Please upload more videos about interview sessions for Power bi and Data Analyst, especially the metrics which are used to evaluate the candidates.

    • @hogolytics
      @hogolytics 3 месяца назад

      Thanks Sahar, sure. Will upload more.

  • @marcemurallas
    @marcemurallas 3 месяца назад

    Gracias

  • @marcemurallas
    @marcemurallas 3 месяца назад

    Gracias :)

  • @WaleedMohamed-r3x
    @WaleedMohamed-r3x 3 месяца назад

    Thanks alot

  • @persiorak20D
    @persiorak20D 3 месяца назад

    what if the data is from a sharepoint list? the button on the report is not refreshing after i update the sharepoint.

  • @WannaTryChannel
    @WannaTryChannel 3 месяца назад

    Thank you!

  • @juandavidardilatorres9126
    @juandavidardilatorres9126 3 месяца назад

    Hello sir, thanks for the video. I noted that the box that contained the last refresh time didn’t change. Do you know how to fix that?

  • @rezaamini8580
    @rezaamini8580 3 месяца назад

    درود بر شما با تشکراکسلی دارم شامل حروف سال به فارسی مثلا 1390 که بخشی از آنها با فونت انگلیسی هستند و بخشی با فونت فارسی. بخشی که فونت انگلیسی است به راحتی در Power Query خوانده می شود اما آن بخشی که فونت فارسی دارد Error می دهد. راهکار چیست؟ با تشکرReza Amini

    • @hogolytics
      @hogolytics 3 месяца назад

      Hi Reza, thanks for your comment. Unfortunately I haven’t used Farsi font in Power BI. I used Power BI in English version. Don’t have any idea about your issue.

  • @ParthasarathyLS
    @ParthasarathyLS 3 месяца назад

    Very nice and useful.

    • @hogolytics
      @hogolytics 3 месяца назад

      Thanks for your comment

  • @DZX5000
    @DZX5000 3 месяца назад

    this seems sketchy 😂

  • @duongngonang
    @duongngonang 3 месяца назад

    Thanks you for your sharing! however my data table over 1000 row, It's send email within 1000 row. could you please help to share for that in case data table >1000 row :)

  • @arunvirmani34
    @arunvirmani34 3 месяца назад

    How can we get original theme back?

  • @ianmichelle5511
    @ianmichelle5511 3 месяца назад

    I thought the keywords RangeStart and RangeEnd were used for incremental refresh.

  • @shwetkumar1719
    @shwetkumar1719 4 месяца назад

    Same issue I am getting when I am getting the data from API through ODBC can it be done through it?

  • @shwetkumar1719
    @shwetkumar1719 4 месяца назад

    let Source = Odbc.DataSource("dsn=TestDWH_Appointment", [HierarchicalNavigation=true]), DATA_Schema = Source{[Name="DATA",Kind="Schema"]}[Data], result_View = DATA_Schema{[Name="result",Kind="View"]}[Data], #"Filtered Rows" = Table.SelectRows(result_View, each [appointmentDate] >= RangeStart and [appointmentDate] <= RangeEnd) in #"Filtered Rows" Sir this is my code i can see native query till Navigation but when i filter it do not show

  • @kevinsanchez627
    @kevinsanchez627 4 месяца назад

    Can you export a matrix table data as csv?

  • @narenchitra1638
    @narenchitra1638 4 месяца назад

    I'm getting error as below when triggering manully and when go back to the report the run option is not enabled. can some suggest on this. please ' The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: entity.'.

    • @kevinsanchez627
      @kevinsanchez627 4 месяца назад

      I was getting the same error. Make sure you hit save and apply once you have fixed your error. Then go back to the report and run the Data Flow.

  • @pmo4325
    @pmo4325 4 месяца назад

    This is EXACTLY what I've been trying to do for days. You sir, are a GENIUS!

    • @hogolytics
      @hogolytics 4 месяца назад

      @@pmo4325 Thanks and happy it was helpful for you

  • @blasegarrecht7330
    @blasegarrecht7330 4 месяца назад

    What if you don't want a button? How would you handle a monthly set day of month refresh since Power BI doesn't allow this? I want to just use refresh dataset from power automate, and then schedule it on 7th day of the month

  • @hhjkjjhhhjjjjj
    @hhjkjjhhhjjjjj 4 месяца назад

    Thank You Sir!

  • @chetnachaudhary8481
    @chetnachaudhary8481 4 месяца назад

    Thank you so much for this video. I was able to achieve what I was looking for.

  • @n4ishuu
    @n4ishuu 4 месяца назад

    The flow is working and I am getting the output as expected, the only issue is I am getting multiple emails after triggering the flow.

    • @TheRealKarinaRusher
      @TheRealKarinaRusher 3 месяца назад

      Did you resolved? Because I have the same issue, actually I need to send to different emails depends of the filter and the mail duplicates depending of the result 😔😔

    • @n4ishuu
      @n4ishuu 3 месяца назад

      @@TheRealKarinaRusher rather using Outlook to get the output, I connected the flow to the sharepoint to get the file saved to a folder which is helping me at the moment.

    • @TheRealKarinaRusher
      @TheRealKarinaRusher 3 месяца назад

      @@n4ishuu i already fixed if you are interested

  • @RDBclub40
    @RDBclub40 4 месяца назад

    Thanks

  • @PFBruno3
    @PFBruno3 4 месяца назад

    Brilliant, thanks!

  • @chongqiuhen
    @chongqiuhen 4 месяца назад

    It's a video which is really underrated! May you be blessed!

  • @josephudoabasi5859
    @josephudoabasi5859 4 месяца назад

    For some reasons, it didn’t work for me, I was only able to see “Microsoft Power Automate” nothing else

  • @jozefswistak3226
    @jozefswistak3226 5 месяцев назад

    Thank You for the video. Does it work when Power BI on my computer is closed? How can I make it work out of access to my computer but refresh it online?

  • @utubebellamkonda
    @utubebellamkonda 5 месяцев назад

    What if I have more than 3 datasets? Can we get items from share point list and loop through?

  • @akru96
    @akru96 5 месяцев назад

    Nice video. Thank you for your explanation!

  • @fariheyd5406
    @fariheyd5406 5 месяцев назад

    Very well explained Shahab!

  • @MrDPavlyuchenko
    @MrDPavlyuchenko 5 месяцев назад

    I have already gone through all the shamanic rites, dancing with a tambourine.... It didn't work until I changed the names of the parameters to RangeStart and RangeEnd. It's just awesome:) So much searching and such a stupid solution.....

  • @9988terminator
    @9988terminator 5 месяцев назад

    Great explanation. Thank you

  • @paulcommerford2609
    @paulcommerford2609 5 месяцев назад

    Thank you, Persian John Lovitz

  • @micchiro14
    @micchiro14 5 месяцев назад

    will this work for end users with viewing access on the workspace, and free license only?

  • @MrTC-rv3jo
    @MrTC-rv3jo 5 месяцев назад

    Great video! Any idea how do I make this with a schedule cloud flow and not a click button? Im not able to get the CSV in the format of a table (only as a one-line output inside the CSV file) .In my case, it is sending an email but I want to send the output table as a CSV file... thanks!