Line Chart Monthly - From YTD Dataset

[Teklers]

Hello everyone,

I have a data set YTD,  i  am trying to make line chart on monthly values/ calculations ,
Whenever i put my formula to chart it only shows YTD values at each month. (I Added picture)

Can you help me , please

Data set example

Sales means Brüt Satış in our language
Period means Dönem in our language Dönem 1 =January sales 5
                                                                               Dönem 2=January to February sales 12 

                                                                               Dönem 3= January to March sales 19 etc.. it goes like this

 

(Sum({<[Dönem]={">=$(=date(date#(yearstart([Dönem]), 'MM/DD/YYYY') ,'MM-YYYY'))<=$(=[Dönem])"}>}([Brüt Satış])))

  

[Teklers]

up:(

[Rams-]

Hi,

I would like to suggest you just to use:

Sum({<[Dönem]={">=$(=Yearstart([Dönem]))<=$(=Date([Dönem]))"}>}[Brüt Satış])

If possible can you share your data

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

[Teklers]

here is dataset, ı tried formula which you mentioned , did not work for me

any other idea 😞 ?

[Rams-]

Hi,

This is another way you can create the your line chart:

I have taken Dimension = [Dönem]

Measure = Sum([Brüt Ciro])

[Teklers]

Hi
This chart show us Year to Date , Results on each Dönem,

I want to see monthly result on each Dönem in that line chart

for example

01-2022  2.159 
02-2022   4.717-2.159 = 2.558
.
.
.

[Teklers]

Up 😞

[Rams-]

Hi,

try to use this expression:

Sum([Brüt Ciro]) - rangesum(above([Brüt Ciro]))

Output: