cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
arjunpowerbi Frequent Visitor
Frequent Visitor

earlier function with mutliple criteria

hi,

 

i am stuck with problem having two creteria, using earlier function.

  

Unit | Rate |Date 

Cat |5       | 01-12-2017 1:25

Cat |4       | 02-12-2017 2:25

Rat |9       | 01-12-2017 3:25

Cat |3       | 02-12-2017 4:25

Cat |2       | 01-12-2017 6:25

Rat |8       | 01-12-2017 8:25

 

then i want to get the Rate of earlier date & time, of same unit in a calculated column.

 

please help

1 ACCEPTED SOLUTION

Accepted Solutions
v-huizhn-msft Super Contributor
Super Contributor

Re: earlier function with mutliple criteria

Hi @arjunpowerbi,

Please create a calculated column using the formula below.

Column =
LOOKUPVALUE (
    Test[Rate],
    Test[Unit], Test[Unit],
    Test[Date], CALCULATE ( MIN ( Test[Date] ), ALLEXCEPT ( Test, Test[Unit] ) )
)


You will get the expected result as follows.

1.PNG

Best Regards,
Angelia

1 REPLY 1
v-huizhn-msft Super Contributor
Super Contributor

Re: earlier function with mutliple criteria

Hi @arjunpowerbi,

Please create a calculated column using the formula below.

Column =
LOOKUPVALUE (
    Test[Rate],
    Test[Unit], Test[Unit],
    Test[Date], CALCULATE ( MIN ( Test[Date] ), ALLEXCEPT ( Test, Test[Unit] ) )
)


You will get the expected result as follows.

1.PNG

Best Regards,
Angelia

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 207 members 1,686 guests
Please welcome our newest community members: