within of current month until today

[beck_bakytbek]

Hi Folks, 

i got a question, i am bit struggling with following issue, my data do look like:

test:
load * Inline [
MyData, Turnover
28.05.2021, 9
01.06.2021, 1
05.06.2021, 2
12.06.2021, 3
14.06.2021, 4
15.06.2021, 5
16.06.2021, 6
17.06.2021, 7
01.07.2021, 8
];

my issue is, how can i show the data of curren month but until today:

my expeceted output is:  Sum(Turnover) = 10 , i am using this expression:

Sum({<Month = {"$(=Month(Today()))"}>}Turnover), but i receive the whole  Turnover.

Does anybody have any idea how to rectify this issue?

Thanks a lot

Bek

[MayilVahanan · Accepted solution]

Hi

Try like below

Sum({<MyData = {">=$(=MonthStart(Today()))<=$(=Today())"}>}Turnover)

[beck_bakytbek]

Hi Mayil Vahanan R,

thanks a lot for your valuable time and your help