Measure that refers to dimension

[v_n]

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?

[MayilVahanan · Accepted solution]

Hi 

Try with If condition

Sum(If(Base_Date <= Due_Date, Amount))

Hope Base_Date and Due_Date are in same table

[v_n]

Perfect! Thanks a lot!