Forum Discussion

melfisch's avatar
melfisch
New Member
4 years ago
Solved

Calculated Columns

I'm trying to study this module:

 

https://docs.microsoft.com/en-us/learn/modules/model-data-power-bi/4-optimize-data-models

 

I completed the previous module regarding calculated columns. But I'm struggling to figure out how to create a calculated column that will get me the same results in the above module's images. Right now every bar has the same number. Any assistance would be very much appreciated.

Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    Hi melfisch 

     

    If every bar has the same number, it may have to do with the relationships in your Data Model.  Have you looked at the relationships to ensure they are structured properly from your Date table to the Fact table?

     

    All the best.

    Theo 

3 Replies

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    Hi melfisch 

     

    If every bar has the same number, it may have to do with the relationships in your Data Model.  Have you looked at the relationships to ensure they are structured properly from your Date table to the Fact table?

     

    All the best.

    Theo 

    • melfisch's avatar
      melfisch
      New Member
      4 years ago

      Thank you for your suggestion. It was exactly what I needed to set me on the right path. Very much appreciated.

      • TheoC's avatar
        TheoC
        Community Champion
        4 years ago

        Great to hear melfisch! All the best with your studies and Power BI journey!