Forum Discussion

mon's avatar
mon
Frequent Visitor
3 years ago

How to divide two measures which are based on two different dates coming from the same table?

I Have created two measures. One measure is 'total device' which is based on 'shipped date' column from the 'device' table. I also created another measure named 'shipped device returned' which is bas...
Tips and Tricks
SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
3 years ago

mon, What is the Business description of the measure and logic? Do you need to know % of returned devices based on the date or order?


Share sample data and expected results.

mon's avatar
mon
Frequent Visitor
3 years ago

Hi SivaMani  Thanks for your reply.

Yes I need to find out the ratio percentage of returned devices( by the formula: divide 'total device' measure values by 'shipped device returned' )