Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
majid_75
Helper I
Helper I

Dax Measure with Forecast

Hello,

 

I want a  bar chart or aother like this image :

 

I have a select Year and  Month : 2020 and 08

 

image.png

 

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!

1 ACCEPTED SOLUTION
CNENFRNL
Community Champion
Community Champion

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
    )

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

2 REPLIES 2
majid_75
Helper I
Helper I

Hello @CNENFRNL ,

 

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

CNENFRNL
Community Champion
Community Champion

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
    )

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.