cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alessandra
Helper I
Helper I

Get the Maximum Price by Date

Hi everyone,

I have two columns of dates: DateBD and DateCust, if the dates are the same then I want to get the maximum price

I've already calculated the maximum price by channel, but I want to add the date validation above.

 

MaxP = IF(SUM(E1_T0_C0509_P0001_F1[Channel])=0,MAX(E1_T0_C0509_P0001_F1[Price]),"-")

 

Here is an Excel of what I'm trying to do.

https://drive.google.com/file/d/1qz3EVmdeZCVucsyZc9DFJB6BUbT3-C_P/view?usp=sharing

 

Thank You.

 

1 ACCEPTED SOLUTION

Try following

 

add new column

 

Do we need max price = if(Table2[DateBD] = Table2[DateCust], 1, 0)

add new measure

 

Max Price = 
IF(sum(Table2[Do we need max price])=1,CALCULATE(MAX(Table2[Price]), All(Table2)),MAX(Table2[Price]))






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

3 REPLIES 3
parry2k
Super User
Super User

@Alessandra you want maximum price across all the dataset where both dates are equal?






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Hi @parry2k,

 

Yes, I want to get the maximum price where only both dates are equal 🙂 

 

Try following

 

add new column

 

Do we need max price = if(Table2[DateBD] = Table2[DateCust], 1, 0)

add new measure

 

Max Price = 
IF(sum(Table2[Do we need max price])=1,CALCULATE(MAX(Table2[Price]), All(Table2)),MAX(Table2[Price]))






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.