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.
Hi 34583458hhdnsk ,
If the provided answer was helpful, please mark it as "Accept as solution" and click "Yes" if you found it helpful, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Regards,
Chaithra.