Forum Discussion

qwertzuiop's avatar
qwertzuiop
Advocate III
3 years ago
Solved

Calculated Column (From Month Values to Average Quarter Values)

Dear Power BI-Community Following problem to solve: Let's assume this table: Rating for Products Product Month Rating (Monthly) Quarter AVG Rating (Quarterly)  A 01.01.2022 4....
Need Help
  • ribisht17's avatar
    ribisht17
    3 years ago

    Would you like to try with Bar Chart ?

    For comparision Bar can be a good option here

     

    Solution = IF( CALCULATE(MAX('Average Rating'[Month]),
    ALLEXCEPT('Average Rating','Average Rating'[Quarter]))='Average Rating'[Month],'Average Rating'[Average Column],0)

    With line it can give a false picture

     

    Regards,

    Ritesh

    Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
    My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

     

ribisht17's avatar
ribisht17
Super User
3 years ago

qwertzuiop 

 

Please use this DAX

Average Column = CALCULATE(AVERAGE('Average Rating'[Rating (Monthly)]),ALLEXCEPT('Average Rating','Average Rating'[Product],'Average Rating'[Quarter]))

 


 

Regards,
Ritesh
  • qwertzuiop's avatar
    qwertzuiop
    Advocate III
    3 years ago

    Thank you so much for your support ribisht17
    I will accept your answer as solution.

    Maybe you can help me out a bit more.
    Is there a way to set all the non marked cell to blank.
    In this case i would only have one value per quarter


    As an example
    Don't like that Quarter has also 3 values per Month

     



    Cheers
    qwertzuiop

     

    • ribisht17's avatar
      ribisht17
      Super User
      3 years ago

      Would you like to try with Bar Chart ?

      For comparision Bar can be a good option here

       

      Solution = IF( CALCULATE(MAX('Average Rating'[Month]),
      ALLEXCEPT('Average Rating','Average Rating'[Quarter]))='Average Rating'[Month],'Average Rating'[Average Column],0)

      With line it can give a false picture

       

      Regards,

      Ritesh

      Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
      My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series