Forum Discussion

34583458hhdnsk's avatar
34583458hhdnsk
Frequent Visitor
1 year ago
Solved

New Column Creation Help

My data is structured like so:      In the Data column I have different labels such as PV, Number of Cards, etc. I would like to create a new data field titled: Spend per Card where it...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    34583458hhdnsk 

    you can try to create a measure for this

    Measure = DIVIDE(sumx(FILTER('Table','Table'[Data]="PV"),'Table'[Number(USD)]),sumx(FILTER('Table','Table'[Data]="Number of Cards"),'Table'[Number(USD)]))
     
    for JPY you can create a similar measure to get the speed
     
    pls see the attachment below

     

     

ryan_mayu's avatar
ryan_mayu
Super User
1 year ago

what's the expected output based on this sample data?

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    1 year ago

    34583458hhdnsk 

    you can try to create a measure for this

    Measure = DIVIDE(sumx(FILTER('Table','Table'[Data]="PV"),'Table'[Number(USD)]),sumx(FILTER('Table','Table'[Data]="Number of Cards"),'Table'[Number(USD)]))
     
    for JPY you can create a similar measure to get the speed
     
    pls see the attachment below