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.
| Year | Month | Article | Revenue Act | Revenue LY |
| 2024 | 1 | 123 | 500 | |
| 2024 | 2 | 123 | | 500 |
| 2024 | 3 | 123 | 500 | 500 |
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:
| Year | Month | Article | Revenue Act | Revenue LY | Flag |
| 2024 | 1 | 123 | 500 | | 0 |
| 2024 | 2 | 123 | | 500 | 0 |
| 2024 | 3 | 123 | 500 | 500 | 1 |
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
