Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
mon
Frequent Visitor

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 based on return date from the device table.

Now I have to divide 'total device' measure values by 'shipped device returned' measure values. But the values are coming wrong as 'total device' and 'shipped device returned' are based  on two different dates. Please kindly guide me how to perform the division of the values for these two measures?

2 REPLIES 2
SivaMani
Resident Rockstar
Resident Rockstar

@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
Frequent Visitor

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' ) 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.