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

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi 34583458hhdnsk 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you