Lowest Sale Date

[Syndicate_Admin]

Good!! Someone knows how to identify the lowest sale date in a year. I have a sales table and calendar. I need to know what was the lowest selling day during the year.

Thank you

[Syndicate_Admin]

Thank you very much for the help.

Actually all the formulas worked.

I keep the last one, because by modifying I could also determine the day of greatest sale. Thank you

[v-zhangti · Accepted solution]

Hi, @Syndicate_Admin 

If it's more than a year, you can try the following.

Measure = 
VAR _minsales =
    CALCULATE ( MIN ( 'Table'[Sales] ), ALLEXCEPT ( 'Date', 'Date'[Year] ) )
RETURN
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER ( ALL ( 'Table' ), [Sales] = _minsales ),
        FILTER ( ALL ( 'Date' ), [Year] = SELECTEDVALUE ( 'Date'[Year] ) )
    )

Result:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Thennarasu_R]

Hi
@Syndicate_Admin 
Do this Measure . you will get your output
First thing Creare one Min Sales
1.Min Sales=min (Sales Colunm)
and then use this formula

Thanks ,
Thennarasu

[FreemanZ]

hi @Syndicate_Admin 

Supposing you have two columns in sales table: date and amt.

try to create a measure like:

LowestDay =

VAR _lowestsales = 

CALCULATE(MIN(TableName[amt]), ALL(TableName))

RETURN

MINX(

    FILTER(

        TableName,

        TableName[amt] = _lowestsales

    ),

    TableName[Date]

)