Dax Measure with Forecast

[majid_75]

Hello,

I want a  bar chart or aother like this image :

I have a select Year and  Month : 2020 and 08

So Blue is my measure total sale for example 01/01/2020 until 31/08/2020 :
Total Sales = Sum(Sales)

And Purple is my measure Pipe 01/09/2020 until 31/12/2020:

Pipe = CALCULATE(

[forcast],

FILTER(

ALL('Date'),

'Date'[Year]=YEAR(DATE(SELECTEDVALUE('Date'[Year]),SELECTEDVALUE('Date'[Month]),1 ))

&& 'Date'[Yearmonth] > SELECTEDVALUE('Date'[Yearmonth])

&& 'Date'[Date] <= ENDOFYEAR('Date'[Date])

)

)

But it's don't work, pls help me!

Thanks!

[majid_75]

Hello @CNENFRNL ,

Thanks you very much but it's don't work.

[CNENFRNL · Accepted solution]

Hi, @majid_75 , I assume you're intended to apply filters this way,

Pipe =
VAR __EndOfYr = ENDOFYEAR ( 'Date'[Date] )
RETURN
    CALCULATE (
        [forcast],
        'Date'[Yearmonth] > SELECTEDVALUE ( 'Date'[Yearmonth] ),
        'Date'[Date] <= __EndOfYr
    )