Forum Discussion
Syndicate_Admin
Administrator
AdministratorLowest Sale Date
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
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.
Syndicate_AdminAdministrator
AdministratorThank 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