Forum Discussion
Advocate IIWhy is Power BI doing that?
I initially posted this query (Create column of daily values summed across a month) about how to calculate [Value mth] and [Value yr] from the below picture, which was answered correctly (blue table in picture)
I then added [Value MTD] as a quick measure to the table (red table) and everything is ok.
I then added [Value YTD] as a quick measure to the table (yellow table) and everything is ok for the first month (January 2014).
However, [Value YTD] resets at zero on 1 February 2014 and each day in February 2014 is repeated twice. Each day in March 2014 is repeated three times, April 2014 four times etc.
Why is Power BI displaying the yellow table like it is?
If I remove Value mth from the yellow table, it displays as expected.
I'm at least slightly uncomfortable w/ using value columns ... directly. Yes, power bi will make an implicit measure... typically. But I always prefer to create an explicit measure (likely just a SUM() )
Can you double check that the field is being summarized in some reasonable way in the visual properties?
4 Replies
mbeggAnonymous yes on dates (it is Power BI date heirarchy). [Value], [Value mth], [Value yr] are columns. [Value MTD] & [Value YTD] are measures
I'm at least slightly uncomfortable w/ using value columns ... directly. Yes, power bi will make an implicit measure... typically. But I always prefer to create an explicit measure (likely just a SUM() )
Can you double check that the field is being summarized in some reasonable way in the visual properties?