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

     

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi qwertzuiop 

try like:

NewColumn =
AVERAGEX(
   FILTER(
         TableName,
         TableName[Product]=EARLIER(TableName[Product])&&TableName[Quarter]=EARLIER(TableName[Quarter])
    ),
    TableName[Rating (Monthly)]
)