dont show current and previous month until certain date

[Pikachu-Power]

Hello,

I have a bar chart (over 12 month) for the following measure:

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

In the bar chart I dont wont to show the current and previous month. but after the middle of the current month (when we reached the 15th) I want to show the previous month.

had often the problem that my measure also cuts the month of the previous years 2019, 2018...

What is the best way to do that?

[lbendlin · Accepted solution]

This is quite easy to implement if you can ensure daily updates to the data source. Create a calculated column that checks the day of the month for "Today" and can act as a true/false flag for your other measures.

Pseudo logic: for each date

if (yearmonth(date)<yearmonth(today) && day(today)>14 á yearmonth(date)<yearmonth(today)-1,1,0)

[Pikachu-Power]

Thank you very much! yearmonth doesnt exist... so I used the normal date in combination with EOMONTH.