Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Revenue Formula

I have this table: I didn't post revenue amounts for security reasons, but the column is just called "revenue" and there is an amount associated with each invoice date. What I'm trying to ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi mrainey,

     

    It's a classic running total question. Create a measure and use DAX formula like pattern below:

    Result =
CALCULATE (
    SUM ( table[value] ),
    ALLEXCEPT ( table, table[Co] ),
    FILTER (
        table,
        table[Invoice Date]
            >= MAX ( table[Invoice Date] ) - 4
            && table[Invoice Date]
                <= MAX ( table[Invoice Date] - 1 )
    )
)
    * 4

    Regards,

    Jimmy Tao

kcantor's avatar
kcantor
Community Champion
8 years ago

AnonymousI would recommend just creating th calculation without the date constraints. When you put it on the report page, load your datekey as a visual, page, or report level filter and use the Relative Date filter function to set it for "In the last 3 months" which will cause the calculation to be dynamic.