Forum Discussion
Filter table on values not empty depending on date
Hi there, I have a table looking like this: GTIN Date Amount Revenue 4004231481559 17.04.2024 20 499,20 4004338782047 26.04.2024 2 14,20 4004625602003 04.04.2024 1 192,47 ...
johnbasha33
Super User
Super UserAnonymous
1.Create a Measure for April Revenue
April Revenue =
CALCULATE(
SUM(Sheet1[Revenue]),
FILTER(
ALL(Sheet1),
MONTH(Sheet1[Date]) = 4
)
)
2.Create a Measure for May Revenue
May Revenue =
CALCULATE(
SUM(Sheet1[Revenue]),
FILTER(
ALL(Sheet1),
MONTH(Sheet1[Date]) = 5
)
)
3.Create a Measure to Check if Both Months Have Values*
Both Months Have Values =
IF(
NOT(ISBLANK([April Revenue])) && NOT(ISBLANK([May Revenue])),
1,
0
)
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
johnbasha33 I have tried this already, but the first two measures deliver the sum of revenue for all articles, not of each article. So that does not work for my issue.
Any other ideas?