expand IF forumula by layer

[Pikachu-Power]

Hi all,

I have a measure in the calender table that shows me all bar charts until month ago after 15th of current month:

Measure = if (Calender[Date] < EOMONTH(TODAY(),-1)+1 && DAY(TODAY()) > 14 || Calender[Date] < EOMONTH(TODAY(),-2)+1, TRUE(), FALSE())

I put the measure in the filter pane and say TRUE().

The bar chart shows "Is Values" and "Forecast Values" separated in Layer. So the above measure I want to apply on "Is Values" but not "Forecast Values".

The formula for the bar chart is:

MeasureBarChart = CALCULATE( SUM(Table[Value]), Table[Position] = "DB")

I think I have to change the MeasureBarChart instead of the Measure right?

[selimovd]

Hey @Pikachu-Power ,

to clarify, the "Measure" is a calculated column in the date table or a measure?

Can you post screenshots of your problem? That makes it easier to understand.

Thank you and best regards

Denis

[Pikachu-Power]

Oh yes, sorry! It is a calculated column in the date table 😊

Example where i use TRUE():

But I want that the forecast values (blue values) go until December, so that the enduser can see forecast for the whole year. 

[Pikachu-Power · Accepted solution]

I could find a way:

To wrap MeasureBarChart in a SWITCH ( TRUE(), ... ) and use the date limitation to the "Is Values" part.

I think that should be the best way?