cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
ojhassonu
Frequent Visitor

How to get Latest status from Multiple rows.

‎02-08-2023 10:49 AM

Dear Folks,

I am pretty new in DAX, and I would like to get the latest status of the position. Below is the screenshot for your reference.

Can someone help me to write DAX for the same. I have attached the sample data pbix file as well.

 

https://drive.google.com/file/d/14Iyx355XXoTawhpB1iiuIA_Y2eEBePU1/view?usp=share_link

ojhassonu_1-1675881915368.png

ojhassonu_2-1675882162622.png

 

 

Labels:
Message 1 of 3
306 Views
0
1 ACCEPTED SOLUTION
2 REPLIES 2
ojhassonu
Frequent Visitor
In response to amitchandak

‎02-22-2023 03:26 AM

Thanks Amit for the reply.

 

No, I don't have any date column. I don't want to add Index Column in huge volume of data. It would not help.

 

Regards,

Sonu

 

Message 3 of 3
176 Views
0

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All