Forum Discussion
Line chart
Hej, for some reason the curve shows the same values for future months for which we have not yet entered data into the Excel. Even there are not even empty cells for this data In the second pi...
Sorry, I did't get it (
In powerBi I have my formula like this:
In powerBi I have my formula like this:
Running total =
VAR CurrentMonth = MAX ( 'Reach unique'[Month].[Date] )
RETURN
CALCULATE (
SUM ( 'Reach unique'[Value] ),
FILTER (
ALLSELECTED ( 'Reach unique'[Month].[Date] ),
'Reach unique'[Month].[Date] <= CurrentMonth
)
)
I collect my database in Excel file and link it with PowerBi. And I make calculation total already in PowerBi program. I did't understend there I could add the new collumn as you discrubed in a massage.
Do you have any saggestions how I could modify my formula ?
Many thanks,
Anhelina
Do you have any saggestions how I could modify my formula ?
Many thanks,
Anhelina
angelina_tr Why is your "VAR CurrentMonth" saving the maximum date instead of the current date?
- Good question! I replase it with "today"
But now my curve looks like a line ande include future monthes. I have no idea why- I changed my time zone to USA and it helps before. (I am localy in Europe)
And curves shows future munthes also now. As it was Can you create a year to date column in your date table like I suggested, and use a ytd = 1 filter in your expression to sum values?
- No, because have my data in Excel. And reverse the monthes