topic Re: Date Button does not overwrite Date in the set analysis in App Development

Date Button does not overwrite Date in the set analysis

Ramina — Wed, 24 Jul 2024 12:11:48 GMT

Hello,

I ' m looking for help with a following problem:

I have a button which shows next 6 months. The formula behind the action is:

=Concat(distinct{$<Date={">=$(=monthstart(today(),1))"}>*$<Date={"<$(=monthstart(today(),7))"}>} Date, ';')

Then I have a formula of a Measure:

sum({<Date={">=$(=monthstart(today(),1))"}>}[Demand [hour]]])

The button does not overwerite date selection in the formula, it ignores it completely.

Cheers

Ramina

hic — Wed, 24 Jul 2024 19:04:16 GMT

If you have a set expression in your measure that defines a new set of dates, this should have precedence over the selection.

Try
{<Date*={">=$(=monthstart(today(),1))"}>}
instead of
{<Date={">=$(=monthstart(today(),1))"}>}

HIC

Ramina — Tue, 20 Aug 2024 12:29:14 GMT

Hey Hic, thank you - it functioned! Just a question, what does this * actually do before the 'Date'?