Forum Discussion
Solved
Spend per card calculation
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 calcu...
Hi 34583458hhdnsk ,
You can do it by using this DAX measure spend per card = DIVIDE([PV], [Number of Cards]), but before adding the custom column, confirm that PV and Number of cards columns are visible and populated in the preview after the step pivot, if not, the pivot step needs to be corrected.
Thanks and regards,
Chaithra.
v-echaithra
Community Support
Community SupportAs we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra.