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

     

     

maruthisp's avatar
maruthisp
Icon for Super User rankSuper User
1 year ago

Hi 34583458hhdnsk ,

As I am not comfortable with Power Query , why don't you try DAX expression to do the same?
Hoping your data model has 2 measures

PV = CALCULATE( SUM( Table[Value] ), Table[Data] = "PV" )

NumberOfCards = CALCULATE( SUM( Table[Value] ), Table[Data] = "Number of Cards" )

Create a 3 measure:
Spend per Card =
DIVIDE(
[PV],
[NumberOfCards],
BLANK() // or 0
)


Please let me know if you have further questions.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X