How do I create such column in Power BI: I sell today but will get my money three months from now?

[Anonymous]

Hey guys, I've got this issue on Power BI. Suppose I sell some products in July, but I will get my money only after 3 months. I want to create a Cash-In column where the values will be shifted 3 cells down. How can I do it in Power BI? Thank you

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may refer to the DAX below.

Column =
VAR m = Table1[Month]
RETURN
    SUMX (
        FILTER ( Table1, Table1[Month] = m - 3 ),
        Table1[Quantity] * Table1[Price]
    )
        + 0

[Anonymous]

Thank you, @v-chuncz-msft, I appreciate your help :).