Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

dont show current and previous month until certain date

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?
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    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)

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
      Pikachu-Power
      Icon for Impactful Individual rankImpactful Individual
      5 years ago

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