GENERATESERIES based on a measure

[cristianml]

Hi,

I want to create  GENERATESERIES based on a measure: 

How can I  modify the measure to fix the error ?

Target =

VAR VAR1 = DIVIDE(([_Actual + CBP Rev]-[_Actual + Backlog Rev]), [_Actual + CBP Rev])

RETURN

GENERATESERIES(MIN(VAR1,MAX([VAR1])),.1)

Thanks

[v-yanjiang-msft · Accepted solution]

Hi @cristianml ,

If you want to generate series from the minum VAR1 value of the table to the maxmum VAR1 value of the table, you should modify it like this:

Target =
VAR VAR1 =
    DIVIDE (
        ( [_Actual + CBP Rev] - [_Actual + Backlog Rev] ),
        [_Actual + CBP Rev]
    )
RETURN
    GENERATESERIES (
        MINX ( ALL ( 'Table' ), VAR1 ),
        MAXX ( ALL ( 'Table' ), VAR1 ),
        .1
    )

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ribisht17]

@cristianml 

Do you need MAX there?

Remove MAX and then TRY >> GENERATESERIES(MIN(VAR1,MAX([VAR Rev])),.1)

Regards,

Ritesh