Forum Discussion

jonbox's avatar
jonbox
Icon for Helper II rankHelper II
4 years ago

Cumulative result per month

Hi, i'm trying to create a measure that accumulates the result per month so that when shown in the line graph, taking the total as an example to be 2.0m in may, 11m june, 11.8m in july, 12.3 in augus...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

jonbox , You can consider suggestion of truptis . But as you have a date, Create a date table; Join with date of your table and use month year on-axis from date table

 

Try measure like

 

total =
CALCULATE(
SUM( eforecastingdata[ActualPrediction_USD]),
FILTER(
ALL('Date'),
'Date'[Date] <= MAX('Date'[Date])
))

 


To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

 

 

  • jonbox's avatar
    jonbox
    Icon for Helper II rankHelper II
    4 years ago

    Hi amitchandak,

     

    When you say create a table to organise date and join to existing table, how would i go about doing this?