Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Do not summarize measure in date rollup

I am looking for the proper measure settings that would not summarize the measure over time but would summarize it for a given day. Other BI tools have similar settings to allow to pick the first or the last date's values for a given period.


Example: a table has records for every day, for each account, including opening and closing balances and debits and credits by day. While summarizing debits and credits for a month fpor all accounts makes sense, the opening and closing balances should not be summarized for the month: for beginning balance only the first day's total should be showing and for the closing balance the last day's total. Is there a measure setting to achieve this?

Super User IV
Super User IV

@AdrienneB , check out

-closingbalancemonth ,closingbalancequarter, closingbalanceyear.there are opening function too. Check in the file how firstnonblankvalue has been used

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helper IV
Helper IV

@AdrienneB this video will help you.


thank you.

Super User III
Super User III

You'd need to provide some data with an explanation of what you expect. There aren't "measure settings" per se. There are a set of functions to be used in measures for this, like OPENINGBALNACEMONTH or CLOSINGBALANCEMONTH though they may not be what you are truly after.


How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors