Forum Discussion

KevinColes's avatar
KevinColes
Icon for Helper III rankHelper III
5 years ago

Dynamically Incrementing Month Index

  Hi everyone,   Hoping someone can help me with something that I thought would be easier to do! I have a matrix that shows values on Rows with Fiscal periods as columns and a bunch of financia...
Need Help
bdarbo78's avatar
bdarbo78
Icon for Advocate II rankAdvocate II
5 years ago

Maybe something like this:
DSO =
        VAR _CountOfMonthsWithSales =
                 FILTER ( VALUES ( Calendar[MonthInYear] ), [Revenue] > 0 )
        RETURN
          DIVIDE (
                [AR Running Total],
                DIVIDE ( [Revenue], _CountOfMonthsWithSales ) * 12
          ) * 365

  • KevinColes's avatar
    KevinColes
    Icon for Helper III rankHelper III
    5 years ago

    Hi bdarbo78,

     

    In your example is Calendar[MonthInYear] intended to be the month number within the year (e.g. December = 12, January = 1)?

    If so, this is not what I'm trying to achieve. I don't want to know the position of the month, but rather a count of months with revenue up to that position. E.g. if December is the first month with Revenue, then there is a count of 1 month with Revenue, if January is the second month with Revenue, then there is a count of 2 months up to January with Revenue.

    Thanks,

    Kevin