Forum Discussion

Jacy's avatar
Jacy
Frequent Visitor
7 years ago

Accumulated

Hello, I have a column with value and another with date, in the same table, I need a measure that will accumulate. One issue is that I create a text column that takes the name of the month and the year example "January 2016".

I created a measure that makes this accumulated in the chart, but when I select a specific date, it does not show the accumulated to date, but only the accumulated of that period, I would need what showed accumulated on that date filtered.

The column that I use in the graphic is the culuna text that I quoted.

The one I am using is:


CALCULATE (
[35M - Base - Production];
FILTER (
CALCULATETABLE (
SUMMARIZE (
'Daily QDP';
'Daily QDP' [20F - Class Period];
'Daily QDP' [20F - Period]
);
ALLSELECTED ('daily QDP')
);
ISONORAFTER (
'Daily QDP' [20F - Class Period]; MAX ('Daily QDP' [20F - Rate Period]); DESC;
'Daily QDP' [20F - Period]; MAX ('daily QDP' [20F - Period]); DESC
)
)
)

I can not use allexcept because I have columns to use for filters that are in other tables so allexcept does not accept.

Someone can help?

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support

    hi, Jacy

    Could you please share your sample pbix file and the expected output. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

     

    Best Regards,

    Lin