Forum Discussion

tharaujo85's avatar
tharaujo85
Frequent Visitor
2 years ago
Solved

Retrieve First Date with a measure condition

Hi, This is my first post, so I apologize in advance if I'm not 100% clear. I have a measure that indicates the coverage in months of my inventory. I want to retrieve the first date which that meas...
"Time"
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi tharaujo85 ,

    Thanks for your reply. You can create a measure as below to get it, please check if it can return the expected result...

    Measure =
MINX (
    FILTER ( ALLSELECTED ( DIM_TEMPO ), [PrevEstq] < 3 ),
    DIM_TEMPO[dat_data]
)

    If the above one can't help you get the expected result, you can create a simplified pbix file with fake data. Then share it with us as referred in my previous post.

    How to upload PBI in Community

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi tharaujo85 ,

Thanks for your reply. You can create a measure as below to get it, please check if it can return the expected result...

Measure =
MINX (
    FILTER ( ALLSELECTED ( DIM_TEMPO ), [PrevEstq] < 3 ),
    DIM_TEMPO[dat_data]
)

If the above one can't help you get the expected result, you can create a simplified pbix file with fake data. Then share it with us as referred in my previous post.

How to upload PBI in Community

Best Regards

tharaujo85's avatar
tharaujo85
Frequent Visitor
2 years ago

Thanks Anonymous ! It worked just fine!