Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

month/quarter/year for cumulative raw data in bar chart

Hi all,


i have following problem:




I have cumulative raw data. plan values for 12 month in 2021. is values currently for 2 month in 2021. i want to show the values in a bar chart. in month level everything works. in quarter/year level i dont see the is values (should always be the last month value).




Clients =
VAR _max = MAXX(Table, Table[Date])

Table[KTNR] = "Clients",
Table[Position] = "Revenue",
FILTER(Table, Table[Date] = _max))
The strange thing is, when i put Table[KTNR] = "Clients" additional in the filter pane it works? but i need it without restrictions in a filter pane because i want combine it with other values later.
So why it works when i put something in a filter pane which is already contained in the measure? 
Super User
Super User

@Pikachu-Power , Not very clear.

Create a date table join with the date and have the month, qtr, and year columns in the date table and use from there.

And try measure like


Clients =
Table[KTNR] = "Clients",
Table[Position] = "Revenue",
FILTER(allselected(Date), Date[Date] = Max(Date[Date])))


To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

I tried with a date table. my and your measure. still no is values for quarter and year. i think it is because the measure looks in quarter 1 for month 3 and there we have no values? and looks for month 12 in year level. 

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors