Pragmatic Works
Pragmatic Works
  • Видео 2 127
  • Просмотров 30 986 934
Dynamic Fiscal Year Date Table using DAX in Power BI
In this video, Amelia demonstrates how to create a Fiscal Year Date Table in Power BI using DAX. If your organization operates on a fiscal calendar different from the standard January-December year, this tutorial is essential for you. Follow along as Amelia guides you through the steps to customize your date table to align with your fiscal year.
👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can visit prag.works/AMELIA40 for 40% off On-Demand Learning!
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next ...
Просмотров: 497

Видео

Save a Single Microsoft Form Attachment to a SharePoint list with Power Automate
Просмотров 47110 часов назад
In this video, Jonathon dives into the intricacies of using Power Automate to transfer attachments from Microsoft Forms into a SharePoint list. Follow along as he demonstrates how to automate the process of collecting form responses, including attachments, and seamlessly adding them to a SharePoint item. This tutorial is ideal for anyone looking to streamline data collection and integration bet...
What's new on the PL-300 Power BI Certification Exam?
Просмотров 1,3 тыс.12 часов назад
Discover the latest updates to the Microsoft PL-300 Power BI Certification Exam as of April 2024 in this comprehensive guide by Angelica Choo Quan from Pragmatic Works. In this video, Angelica dives into the major changes in the PL-300 exam objectives, specifically focusing on enabling personalized visuals and designing accessible Power BI reports. Whether you're preparing for the PL-300 certif...
Microsoft Fabric Trial License Expiring Soon! Don't Lose All Your Fabric Items!
Просмотров 65014 часов назад
In this video, we explore Microsoft Fabric and the challenges users may face when their trial license expires. We discuss the options available to users and explain how to ensure no Fabric artifacts are lost. Watch this video to stay ahead of the game. 👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you...
NEW Updates to the Matrix Visual in Power BI | May 2024 Update
Просмотров 2,6 тыс.17 часов назад
Discover the exciting new updates to the Matrix Visual in Power BI's May 2024 update! Learn how to leverage new layout styles, repeating row headers, and blank row features to make your reports more organized and visually appealing. You'll learn about the new Layout options that match Pivot Table options in Excel. Watch now to take your Power BI reports to the next level! 👍 If you enjoy this vi...
Power BI Data Viz Tips & Tricks - Promo
Просмотров 1,5 тыс.День назад
Sign up at prag.works/lwtn-power-bi-data-viz-tips-tricks-yt Join Greg in this insightful session where attendees will uncover outstanding techniques for enhancing interactivity, visual appeal, and navigation in Power BI reports. Greg will share expert tips on leveraging buttons, tooltips, and mapping strategies to elevate your reports. Participants will learn innovative ways to engage users, ex...
Certifications Schmertifications, Are They Worth It?
Просмотров 554День назад
Learn how technical certifications boost professional development and career advancement. We'll discuss the pros and cons of becoming an indispensable asset to your company through targeted certifications, enhancing job security, and opening new career opportunities. Join us to elevate your professional value in the tech industry. Save 50% on an annual On-Demand Learning subscription at prag.wo...
Power BI DevDash - Women in Technology Edition
Просмотров 1,1 тыс.День назад
Join us for another Power BI DevDash Challenge featuring Pragmatic Works' own Angelica Choo Quan, Allison Gonzalez, and Amelia Roberts. These accomplished data analysts will race to build see who has the data supremacy in building a themed report. Save 50% on an annual On-Demand Learning subscription at prag.works/2024-intergalactic-sale-yt (Valid through June 30, 2024) - - - - - - - - - - - - ...
Getting Started with Real-Time Intelligence in Microsoft Fabric
Просмотров 1 тыс.День назад
Getting Started with Real-Time Intelligence in Microsoft Fabric
Power BI Paginated Reports Power Query - Setting up Parameters
Просмотров 1,5 тыс.День назад
Power BI Paginated Reports Power Query - Setting up Parameters
Create Measures in the Power BI Service with Visual Calculations
Просмотров 1,2 тыс.14 дней назад
Create Measures in the Power BI Service with Visual Calculations
DP-900: Azure Data Fundamentals Review (Course Preview)
Просмотров 25014 дней назад
DP-900: Azure Data Fundamentals Review (Course Preview)
Master the MS-900: Microsoft 365 Fundamentals (Course Preview)
Просмотров 27814 дней назад
Master the MS-900: Microsoft 365 Fundamentals (Course Preview)
Powerful PowerPoint: Presentation Fundamentals (Course Preview)
Просмотров 16514 дней назад
Powerful PowerPoint: Presentation Fundamentals (Course Preview)
Power BI Calculation Groups (Course Preview)
Просмотров 66114 дней назад
Power BI Calculation Groups (Course Preview)
Building Data Literacy: Skills for the Information Age (Course Preview)
Просмотров 22214 дней назад
Building Data Literacy: Skills for the Information Age (Course Preview)
Introduction to SharePoint for End Users (Course Preview)
Просмотров 24814 дней назад
Introduction to SharePoint for End Users (Course Preview)
Navigating the Tech Word as a Minority: Insights and Experiences
Просмотров 26914 дней назад
Navigating the Tech Word as a Minority: Insights and Experiences
Using Entities in Copilot Studio For Teams - Power Platform for Educators
Просмотров 43014 дней назад
Using Entities in Copilot Studio For Teams - Power Platform for Educators
Microsoft Forms & Power BI Integration - Turn Surveys Into Insights!
Просмотров 2,1 тыс.14 дней назад
Microsoft Forms & Power BI Integration - Turn Surveys Into Insights!
Custom Help Pages and Panels for Model-Driven Power Apps
Просмотров 49314 дней назад
Custom Help Pages and Panels for Model-Driven Power Apps
Data Analysts Build a Power BI Solution in 30 minutes - DevDash (Ep. 3)
Просмотров 2,5 тыс.21 день назад
Data Analysts Build a Power BI Solution in 30 minutes - DevDash (Ep. 3)
PL-200 Exam Tutoring | Questions and Answers for the Microsoft Power Platform Certification Exam
Просмотров 75921 день назад
PL-200 Exam Tutoring | Questions and Answers for the Microsoft Power Platform Certification Exam
How To Make a Drillthrough Page in Power BI
Просмотров 2,7 тыс.21 день назад
How To Make a Drillthrough Page in Power BI
Key Influencers Visual Explained - AI Visuals in Power BI
Просмотров 2,9 тыс.21 день назад
Key Influencers Visual Explained - AI Visuals in Power BI
Modern Themes in Canvas Power Apps
Просмотров 72128 дней назад
Modern Themes in Canvas Power Apps
Can Two Power App Developers Beat The Clock In The DevDash Challenge? (Ep. 2)
Просмотров 1,2 тыс.Месяц назад
Can Two Power App Developers Beat The Clock In The DevDash Challenge? (Ep. 2)
Introduction to DAX Query View in Power BI Desktop
Просмотров 4,9 тыс.Месяц назад
Introduction to DAX Query View in Power BI Desktop
PL-900 Power Platform Certification Exam Questions - Each Wrong Answer is an Hour in Waffle House!
Просмотров 559Месяц назад
PL-900 Power Platform Certification Exam Questions - Each Wrong Answer is an Hour in Waffle House!
Microsoft Whiteboard Tutorial for Educators
Просмотров 585Месяц назад
Microsoft Whiteboard Tutorial for Educators

Комментарии

  • @JefferjoneLong-gat
    @JefferjoneLong-gat 40 минут назад

    Hi Allison, since Stepped Layout is now changed to Layout (Tabular), why is it that if I upload to server, it shows an outline format which is so annoying. If I edit in PBI Desktop tabular format works fine, but after uploading to server, the format changes to outline layout.?

  • @Bodybydubs
    @Bodybydubs 11 часов назад

    What if I want to list to only show items where a particular colum is blank?

  • @bernardinusrico9435
    @bernardinusrico9435 12 часов назад

    if users change the visualization with Personalize a visual, are the visuals type going back to before or still at the last visual users made?

  • @babugondarammohan4158
    @babugondarammohan4158 16 часов назад

    Hi

  • @PiyushBhavanaKimmi
    @PiyushBhavanaKimmi 18 часов назад

    Is it enough though to crack an interview?

  • @nealdyxthercentino5576
    @nealdyxthercentino5576 День назад

    do you need to be in an organization or something to use get more visuals in 2:45:00? I am using personal microsoft and it wont allow me

    • @desktopdatacrunching4032
      @desktopdatacrunching4032 17 часов назад

      Bringing in a custom visual does require that you sign in with either a work or school account.

  • @walterstevens8676
    @walterstevens8676 День назад

    Really keen on a data modelling course!

  • @ChrisUK70
    @ChrisUK70 День назад

    I have followed your series so far and replicated what you have done and I cannot see any subscriptions on the account management page of Microsoft Azure Storage after I have logged in.

  • @user-qh5fr3yo1w
    @user-qh5fr3yo1w День назад

    Очень хорошее видео. Автору большое спасибо.

  • @ChrisUK70
    @ChrisUK70 День назад

    Thanks Mitchell, one thing that tripped me up was that I had to add Microsoft.Synapse resource provider to the subscription. ChatGPT gave me the answer!

  • @tawandachoto5946
    @tawandachoto5946 2 дня назад

    Thanks Jonathan. Very useful

  • @kochiisaac1690
    @kochiisaac1690 2 дня назад

  • @pardonmasuka2
    @pardonmasuka2 2 дня назад

    Awesome!

  • @AIwithMahmudul
    @AIwithMahmudul 2 дня назад

    The actual Synapse demo/walkthrough starts at 24:00

  • @OlatunjiAshafa
    @OlatunjiAshafa 2 дня назад

    Please may we have a link to the 9 hour course. Thank you.

  • @AnnieMoore-Design
    @AnnieMoore-Design 3 дня назад

    THANK YOU SO MUCH!! Ive spent all day trying to figure this out. we wee trying to enter company receipts into Microsoft forms and have the bookkeeper (third party company) access the live updating spreadsheet of form responses, but they couldn't see the attachments since they're outside of our organization. Sharepoint we CAN share to them, so I was trying to get forms to upload into sharepoint, with attachments. Thank you so much!!

  • @tinaxu4214
    @tinaxu4214 3 дня назад

    Thank you for the great tutorial with clear speaking! I like the enlarged video image whenever I need a close look, which most of other tutorials don't have. Good job👍👍👍💯

  • @faranbhutta1349
    @faranbhutta1349 3 дня назад

    very informative.

  • @Me2hand
    @Me2hand 3 дня назад

    Thank you a lot for your guideline

  • @DailyVerse-langsong
    @DailyVerse-langsong 3 дня назад

    You are the best High school teacher ever, Thank you for your background.

  • @kristinepalafox3791
    @kristinepalafox3791 3 дня назад

    OMG! THIS IS WHAT I NEEDED! THANK YOU! YOU SAVED MY SANITY!

  • @HerskinMeycauayan
    @HerskinMeycauayan 3 дня назад

    Sir, I have a question, timestamp: 27:19, why did I received an error while signing in? It says that the error is create and authorize OAuth connection failed. How do I fix that?

  • @frankxiao455
    @frankxiao455 4 дня назад

    When I create a table, it did not include the bottom several rows into the table created. It is caused by a blank cell in column A. How do I fix this issue. Since all the columns in my worksheet may have blank cells.

  • @Bondoz007
    @Bondoz007 4 дня назад

    So I'm trying to think of a use case where someone attached something to a form? I never knew people do that. Maybe for onboarding? Submitting medical certs? (Though most HRIS already handle that kind of thing). I'd love to hear a real life case because I'm always looking for new ways to use power automate. Thanks!

  • @pdreo33
    @pdreo33 4 дня назад

    15 ads for a 2h video. Annoying doesn't make justice to it.

  • @victorgladwin2169
    @victorgladwin2169 4 дня назад

    thanks for this wonderfull course. but i need a help. i am following each step for creating report. but i see the sales tables does not have a proper date value in the date column. and then how do we be able to connect the sales fact to the date dimension. valuable reply would be much appreciated.

  • @finik_sashko
    @finik_sashko 4 дня назад

    This man looks like he's streaming from jail 😂

  • @aditisharma7221
    @aditisharma7221 4 дня назад

    LOVED IT !

  • @md.imrulhasan8757
    @md.imrulhasan8757 4 дня назад

    Closing Balance (MAX Last Date) = CALCULATE( SUM('Product Inventory'[Units Balance]), 'Product Inventory'[DateKey] = MAX('Product Inventory'[DateKey]) ) vs Closing Balance (Last Non Blank Date) = CALCULATE( [Inventory Balance], LASTNONBLANK( 'Date'[Date], [Inventory Balance] ) ) first method got extra data in the begining why?

  • @user-qh5fr3yo1w
    @user-qh5fr3yo1w 4 дня назад

    Видио бомбическое. Много просмотрел видео по этой теме, но такое вижу впервые.

  • @Vipurdy
    @Vipurdy 4 дня назад

    What is this? I’m pretty sure differentiating the evolution of a Rolodex to advanced Ai

  • @hia650
    @hia650 4 дня назад

    is this live?

  • @DevendraSingh-tx2pt
    @DevendraSingh-tx2pt 4 дня назад

    How can user see only his records, if his full name is stored in single text column not a owner or ownedby. We have imported excel file in dataverse where employee full name column has user name in single text field

  • @favoureforuoku4622
    @favoureforuoku4622 5 дней назад

    Thank you so much for this video @matthew Peterson. I have a related problem, but in this case, I don't want to delete the old record but want to return only the most recent as a count.

  • @MarcosEnriqueAcevedoHuete
    @MarcosEnriqueAcevedoHuete 5 дней назад

    Thanks, excellent video! Helpful!

  • @asthaarora-de6xi
    @asthaarora-de6xi 5 дней назад

    i followed the exact same thing, but it is not working for me

  • @user-qh5fr3yo1w
    @user-qh5fr3yo1w 5 дней назад

    Очень хорошее видео. Я из России изучаю Power BI.

  • @TheTtuchaa
    @TheTtuchaa 5 дней назад

    You are an exceptional teacher :)

  • @Dansel_B
    @Dansel_B 5 дней назад

    Thank You, Allison

  • @17avskadoo
    @17avskadoo 6 дней назад

    I want to fetch User Email ID from system table 'Microsoft Entra ID' earlier it was called as 'aaaduser' I load that source table in data flow. can you suggest what should I do?

  • @gaborbence6943
    @gaborbence6943 6 дней назад

    never seen someone explaining so clearly. amazing, thank you!

  • @kharchenko28
    @kharchenko28 6 дней назад

    Is it possible to have a parent app and a few child apps inside the parent app? On the parent I want to have search functionality with the list of financial forms. And on the child forms have the Edit/View/Edit forms for each financial form/report. To manage all forms we need more easily.

  • @ugochukwunwasuruba1356
    @ugochukwunwasuruba1356 6 дней назад

    Awesome

  • @FluffyGrl
    @FluffyGrl 6 дней назад

    Is there a way to make this function as an automatic cloud flow rather than having to manually trigger it? I have a yes/no dropdown column and would love to send the email when that is marked yes rather than mark yes, then go into Power Automate to run the flow.

  • @YulianaAldrich-Albisu
    @YulianaAldrich-Albisu 6 дней назад

    I am not seeing the note(annotation) option, even if I only choose annotation it aske me for a relationship and unable to choose one or create a new one.

  • @elrevesyelderecho
    @elrevesyelderecho 6 дней назад

    Thanks for this video Question. This work just for 1 PBI report. What can I do having several PBI reports? All PBI reports are connected to the same data source/Server location and I need to change it to a new Server location. Is there a way to change all data source across all PBI reports rather than open and do it one by one? Thanks

  • @f.s8286
    @f.s8286 6 дней назад

    Great course ! exactly what I needed. Thanks for your explanations and speaking clearly and slowly (I'm French :))

  • @0verTheSpace
    @0verTheSpace 6 дней назад

    This is a great video. One thing I’m struggling with is finding the custom text columns from Project in PowerBI. I’ve searched all the available tables -and I can’t find them! Have you got any ideas which table they’re in?

  • @jhackithompson3274
    @jhackithompson3274 6 дней назад

    perfect video, so helpful! Thank you!

  • @ahmedodawaa4581
    @ahmedodawaa4581 6 дней назад

    Hi @austinlibal I dont know if you are still answering questions here. I have followed the video and doing every step with you. But when I came to the step were you go from get metadata -> filter -> to foreach1 and then invoke pipeline, when I click on run, I get this error: Activity failed because an inner activity failed; Inner activity name: Invoke pipeline1, Error: Operation on target Copy data1 failed: Lakehouse table name should only contain letters, numbers, and underscores. The name must also be no more than 256 characters long. I cant find any answers on how to solve this issue.

    • @austinlibal
      @austinlibal 4 дня назад

      Most likely it is in the parameterized Table name on the copy data activity within the child pipeline. 1:07:19