cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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!

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