Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
I am working on a table in which I want to have a Due Date as a dimension and the Amount as a measure.
So it should look like this:
Due_Date | Amount |
30.11.2021 | 4.125.647 |
31.12.2021 | 2.215.486 |
31.01.2022 | 8.143.413 |
My formula for the amount looks like this:
=Sum({<Base_Date={"<=$(=Due_Date)"}>} [Amount])
Now when I select a Due_Date, it works. But when I have a list of due dates, nothing is displayed.
What am I doing wrong?
Hi
Try with If condition
Sum(If(Base_Date <= Due_Date, Amount))
Hope Base_Date and Due_Date are in same table
Hi
Try with If condition
Sum(If(Base_Date <= Due_Date, Amount))
Hope Base_Date and Due_Date are in same table
Perfect! Thanks a lot!