Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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?
@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.
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' )
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
67 | |
67 | |
42 | |
42 |
User | Count |
---|---|
46 | |
40 | |
28 | |
26 | |
25 |