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

     

     

v-priyankata's avatar
v-priyankata
Community Support
1 year ago

Hi 34583458hhdnsk 

Thanks ryan_mayu maruthisp for your inputs, 34583458hhdnsk May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.