Dynamic Calculation Flag

Hello everyone,

I am new to the forum and have already had a few search attempts, which unfortunately were not very successful.

That's why I'm trying a new post.

I have a fact table. It contains the following information.

Now the problem:

I should build a dynamic flag, if I select a month in the dashboard. e.g. "1" then the flag gets the value "0". Since the row had no value in the last year. If I select the month "3", then I get a value of 1 in the flag.

This would then result in the following table:

However, the flag is now static. I would like the flag to be dynamically set, if I select more than 1 month in the dashboard.

Example:

I select the first 3 months of the year. Then the article was sold in the first 3 months and should be taken into calculation.

I would like to be able to continue calculating with the flag later.

Thanks in forward!

Cheers