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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Pikachu-Power
Impactful Individual
Impactful Individual

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?
1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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)

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

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)

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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