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
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous Try

PR Compliance -over val =
CALCULATE(
AVERAGE('PR Details'[PR DATA]),
'PR Details'[PR]="Within"
)