Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Count running accruals

Hi all,   I am want to make a measure that counts the current running accruals of a company. Here's how the raw data would look like on the left, and I plan to arrange the data like this on the rig...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    Is that the excepted result you need?

     

    Measure 3 =
SUMX (
    FILTER (
        ALL ( Table2[Supplier] ),
        Table2[Supplier] <= MAX ( Table2[Supplier] )
    ),
    [Measure 2]
)

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hi v-frfei-msft,

 

The result is almost realized. Apologies, I forgot to mention that the accruals for each company, per period should be displayed as a running total. I think I have to edit this part of the code?

VAR maxmonth0 =
    CALCULATE (
        MAX ( 'Central (FLO)'[AfP] ),
        FILTER ( ALL ( 'Central (FLO)' ), 'Central (FLO)'[Company code amount] = 0 ),
        VALUES ( 'Central (FLO)'[Company Name] ),
        KEEPFILTERS ( k )

Thanks for your continuous help.

 

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

Is that the excepted result you need?

 

Measure 3 =
SUMX (
    FILTER (
        ALL ( Table2[Supplier] ),
        Table2[Supplier] <= MAX ( Table2[Supplier] )
    ),
    [Measure 2]
)