Forum Discussion

qwertzuiop's avatar
qwertzuiop
Icon for Advocate III rankAdvocate 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
Icon for Super User rankSuper 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
Icon for Advocate III rankAdvocate 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
    Icon for Super User rankSuper 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