Profit = SUM(Sales[Profit Amount]) Measure

Eric KALONJI 0 Reputation points
2024-05-08T07:28:30.23+00:00

In this tutorial: https://learn.microsoft.com/en-us/training/modules/dax-power-bi-add-measures/2-simple-measures, a few measures need to be created.

However, the Profit = SUM(Sales[Profit Amount]) in particular is producing an error because the Sales table does not have a Profit Amount column.

This question is related to the following Learning Module

Microsoft Power Platform Training
Microsoft Power Platform Training
Microsoft Power Platform: An integrated set of Microsoft business intelligence services.Training: Instruction to develop new skills.
456 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Syed Saleem Peera 7,460 Reputation points Microsoft Vendor
    2024-05-08T10:32:01.95+00:00

    Hi Eric KALONJI,

    Thank you for reaching out to us on Microsoft Q&A forum.  

    Kindly complete all the units in module https://learn.microsoft.com/en-us/training/modules/dax-power-bi-add-measures/

    It's clearly mention in Unit 2 profit column will explain in upcoming units. Kindly refer the below screenshot.

    User's image

    It's explained in Unit 3, kindly refer the below screenshot.

    User's image

    If you are still facing any issue, please let us know in the comments. We are glad to help you.

    If the information is helpful, please Accept Answer so that it would be helpful to community members.

    Thank you.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.