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 mont...
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)

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.