Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

EARLIER functionality in Measure

Hi,   I need a Measure which contains the EARLIER functionality.   My Table ID Type Field Customer Picking Date Best before 1 Banana A X 01.01.2019 01.02.2019 2 Apple A Y ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous 

     

    Try this MEASURE

     

    =
IF (
    SELECTEDVALUE ( TableName[Picking Date] )
        = CALCULATE (
            MIN ( TableName[Picking Date] ),
            VALUES ( TableName[Type] ),
            ALLSELECTED ( TableName )
        ),
    1,
    0
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Zubair_Muhammad ,

 

many thanks for your fast reply and your solution.

First of all the measure works fine. Thank you.

But my column chart don't. Do you know why?

 

 

Best regards

Timo

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

Anonymous 

 

Could you share your file. I will try to help

 

Regards,

Zubair