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
)
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.