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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
BhoomiT
Frequent Visitor

Difference of Rows

working on a project where I want to create measure/DAX of price difference between brands.Using the following data I want to create the price diffrence between Brand A with All other brands for regions.

Sample data:

Brand Name

Region

Date

Price

A

X

22-09-2021

300

B

X

22-09-2021

320

C

X

22-09-2021

310

A

Y

22-09-2021

330

B

Y

22-09-2021

316

C

Y

22-09-2021

321

A

Z

22-09-2021

337

B

Z

22-09-2021

337

C

Z

22-09-2021

310

D

Z

22-09-2021

302

E

Z

22-09-2021

328

F

Z

22-09-2021

335

3 REPLIES 3
v-xiaotang
Community Support
Community Support

Hi @BhoomiT 

try this 

difference = 
    var _PriceA = CALCULATE(MIN('Table'[Price]),FILTER(ALLSELECTED('Table'),'Table'[Brand Name]="A"))
    var _currPrice = MIN('Table'[Price])
return _currPrice-_PriceA

result

vxiaotang_1-1632814274894.png

vxiaotang_0-1632814205376.png

if you need more help, please @ me.

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@BhoomiT , A new column for price of A and then you can take a diff

 

A price = maxx(filter(Table, [region] =earlier( [region] ) && [Brand Name] ="A") , [Price])

 

diff = [Price] -[A price]

 

 

a measure, if needed

 

A price = maxx(filter(allselected(Table), [region] =max( [region] ) && [Brand Name] ="A") , [Price])

Thank You Amit,

 

This is working perfact up to region level filters but, when I tried to calculate it at branch and terittory level ( level down the region) then there is minor deviation in the calculation. 

 

request you to please guide me how can I calculate a measure so that it works for region, branch, terittory filters as well as time filters.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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