Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

split column value based on another column

i have two column    PR Compliance :    PR                         PR DATA Within                      4 Over                         2 Over                         2 Within                  ...
Help appreciated
Help me
Help Requested
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous Try

    PR Compliance -over val =
    CALCULATE(
    AVERAGE('PR Details'[PR DATA]),
    'PR Details'[PR]="Within"
    )
goncalogeraldes's avatar
goncalogeraldes
Super User
5 years ago
Anonymous 
PR Compliance -over val =
CALCULATE(
AVERAGE(VALUE('PR Details'[PR ])),
'PR Details'[PR]="Within"
)
 
Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    goncalogeraldes 

     

    Month        PODetails

    May            over

    May            over

    May            within

    May            over

    June            within

    June          within

    June           over            

    July            within

     

    My percentage  want month wise 

     

    Month       Over          within           Grand Total 

    May            75%         25%                  100%

    June            25%         75%                  100%

     

     

    any idea month wise percentage ? thanks in advance