Forum Discussion

VInciDa's avatar
VInciDa
Regular Visitor
4 years ago
Solved

How to find the First Date using a filter within a Rank Measure

  I have created [Rank] as a measure to capture only the TOP 2 [ Lifts] including ties while making everything else blank. The goal is to create the [First_Date_Rank_2] column that shows the E...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the below picture and the attached pbix file.

    All measures are in the attached pbix file.

    I tried to think in a different way to solve the problem than the previous one.

    I hope this helps to provide an easier way to solve the problem.

    In the below picture, the reason why Rowing exercise shows the top on date is because there is the information of the lift in one of the rows of Rowing.

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

Please check the below picture and the attached pbix file.

All measures are in the attached pbix file.

I tried to think in a different way to solve the problem than the previous one.

I hope this helps to provide an easier way to solve the problem.

In the below picture, the reason why Rowing exercise shows the top on date is because there is the information of the lift in one of the rows of Rowing.

 

VInciDa's avatar
VInciDa
Regular Visitor
4 years ago

This is exactly what I needed thank you