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"
    )
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous Try

PR Compliance -over val =
CALCULATE(
AVERAGE('PR Details'[PR DATA]),
'PR Details'[PR]="Within"
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Greg_Deckler   i have month wise text count value like 

 

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