MSPTDA 23: Two Fact Tables? DAX Power Query or Worksheet Formulas to Convert to 1 Fact Table faq

instructor Instructor: ExcelIsFun instructor-icon
duration Duration: 2.00 duration-icon

This online course provides a solution to the challenge of converting two fact tables into one using Excel worksheet formulas. It explains how to use the SUMPRODUCT function to allocate discounts from the invoice grain to the invoice line grain, and to calculate total invoice sales at the invoice grain. The article also explains how to use the SUMIFS function to calculate total invoice line sales at the invoice line grain.

ADVERTISEMENT

Course Feature Course Overview Course Provider Discussion and Reviews
Go to class

Course Feature

costCost:

Free

providerProvider:

Youtube

certificateCertificate:

Paid Certification

languageLanguage:

English

start dateStart Date:

On-Demand

Course Overview

❗The content presented here is sourced directly from Youtube platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [February 21st, 2023]

MSPTDA 23: Two Fact Tables? DAX Power Query or Worksheet Formulas to Convert to 1 Fact Table is a course designed to help learners understand how to convert two fact tables into one. Learners will gain an understanding of how to use Excel worksheet formulas, DAX formulas, and Power Query to achieve this goal. They will learn how to allocate discounts from invoice grain to invoice line grain, how to allocate shipping from invoice grain to invoice line grain, and how to create Excel reports at product grain. They will also learn how to create DAX measures for shipping, discounts, and sales, as well as how to create % DAX measures for shipping and discounts as a percent of sales. Finally, learners will learn how to create visualizations in Power BI Desktop. This course is ideal for those who want to gain a better understanding of how to use Excel, DAX, and Power Query to convert two fact tables into one.

Course Provider

Provider Youtube's Stats at AZClass

Rating Grade: A This is an established provider widely recognized and trusted by users, and is perfect for all level learners.

Discussion and Reviews

0.0   (Based on 0 reviews)

Start your review of MSPTDA 23: Two Fact Tables? DAX Power Query or Worksheet Formulas to Convert to 1 Fact Table

faq FAQ for Microsoft Power Bi Courses

Q1: Does the course offer certificates upon completion?

Yes, this course offers a free certificate. AZ Class have already checked the course certification options for you. Access the class for more details.

Q2: How do I contact your customer support team for more information?

If you have questions about the course content or need help, you can contact us through "Contact Us" at the bottom of the page.

Q3: Can I take this course for free?

Yes, this is a free course offered by Youtube, please click the "go to class" button to access more details.

Q4: How many people have enrolled in this course?

So far, a total of 0 people have participated in this course. The duration of this course is 2.00 hour(s). Please arrange it according to your own time.

Q5: How Do I Enroll in This Course?

Click the"Go to class" button, then you will arrive at the course detail page.
Watch the video preview to understand the course content.
(Please note that the following steps should be performed on Youtube's official site.)
Find the course description and syllabus for detailed information.
Explore teacher profiles and student reviews.
Add your desired course to your cart.
If you don't have an account yet, sign up while in the cart, and you can start the course immediately.
Once in the cart, select the course you want and click "Enroll."
Youtube may offer a Personal Plan subscription option as well. If the course is part of a subscription, you'll find the option to enroll in the subscription on the course landing page.
If you're looking for additional Microsoft Power Bi courses and certifications, our extensive collection at azclass.net will help you.

close

To provide you with the best possible user experience, we use cookies. By clicking 'accept', you consent to the use of cookies in accordance with our Privacy Policy.