Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Same Value For All Months

Hello,   Here is my fact table:   Dimension Value Execution Period  Execution 266,846,836   Execution 286,169,980   Execution 324,761,947   Execution 81,715,856 01/12/202...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Hope you are creating a measure , and Backlog Execution is a measure too

 

try

a new measure
Burndown =
VAR _period = max('Calendar'[Date])
VAR _burndownBacklog = calculate([Backlog Execution],
filter(
all('Calendar'),
'Calendar'[Date]<=_period))
RETURN
_burndownBacklog