Hi team, can you help me with my scenario:i have line graph where i have to show month wise actuals

[Anonymous]

Create a year and month column for the latest value and then use the line garph analytical option to set up the inbound and ounbound of confidence level like up to 95%

[Anonymous]

hi,Thanks for reply.I am having month slicer already but i want to show jan to dec in line graph,i have actuals timm may and for future months i want to caluclate the formula is divide(latest month actuals,latest month)+latest month value) for example jun value to be caluclated based on may and july based on june like that value to be caluclated till dec. line to be shown new values where actuals is blank. Appreciate your suggestions.

[Anonymous]

Hi Team,

below is some sample data and what i am expecting result please provide Dax function to get future values from june.

how to write this excel formula in dax.

Thanks in advance.

"Value" of Month	1	2	3	4	5	6	7	8	9	10	11	12
Month	jan	feb	mar	apr	may	jun	jul	aug	sep	oct	nov	dec
Actuals	980	936	859	980	825
RR					825	990	1,155	1,320	1,485	1,650	1,815	1,980
Formula						(F5/F1)+F5	(G6/G1)+G6	(H6/H1)+H6	(I6/I1)+I6	(J6/J1)+J6	(K6/K1)+K6	(L6/L1)+L6

[v-zhangti]

Hi, @Anonymous 

You can try the following methods.

RR = 
Var maxmonth=Month(CALCULATE(MAX('Table'[Date]),ALLEXCEPT('Table','Date'[Date])))
Var maxmonthactuals=CALCULATE(SUM('Table'[Actuals ]),FILTER(ALL('Date'),[Month value]=maxmonth))
Var dicide=DIVIDE(maxmonthactuals,maxmonth)+maxmonthactuals
return
IF(SELECTEDVALUE('Date'[Month value])=maxmonth+1,dicide,SUM('Table'[Actuals ]))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Zhanti, Thanks for your reply but i want the values to be shown for july,aug,sep,oct,nov,dec also.jul value to be caluclated based on June and aug value to be caluclated based on Jul and so on till dec. when i create measure using the above formula i can see the result till where i have physical data.

   please revise formula and also confirm month value in your formua is month num from calender table right

[v-zhangti]

Hi, @Anonymous 

Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Create a date table with monthyear column, join that with you date and use that

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

Mark Month year sort as sort column on month year

You can use date hierarchy, Remove qtr and day