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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Zubair_Muhammad 

     

    Sorry but because of our directives I am not able to upload my file.

     

    It is a stacked column chart.

    Axis is "Best before" with Hierarchy year and month and the value is Measure. With a (sum) column in the chart it works fine. So I think there is the problem, but I am not able to sum the measure.