Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
6 years ago
Solved

need formula

Hi there ;   i need your help to create below formula    i have a table as below , calculating rule will be : for each actual month ( acual month is august today) , system will find first day and...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi erhan_79 ,

    According to my understanding, you want to calculate the sum of the first day’s(in table column) amount of current month , right?

    You could use the following formula:

    sum =
VAR _first =
    CALCULATE (
        MIN ( 'SumFirstDayMonth'[Date] ),
        FILTER ( ALL ( SumFirstDayMonth ), 'SumFirstDayMonth'[Status] = "Actual Month" )
    )
RETURN
    CALCULATE (
        SUM ( SumFirstDayMonth[Amount] ),
        FILTER ( ALL ( SumFirstDayMonth ), 'SumFirstDayMonth'[Date] = _first )
)

    My visualization looks like this:

    Is the result what you want? If not, please upload some data samples and expected output.

    Please do mask sensitive data before uploading.

     

    Best Regards,

    Eyelyn Qin

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi erhan_79 ,

According to my understanding, you want to calculate the sum of the first day’s(in table column) amount of current month , right?

You could use the following formula:

sum =
VAR _first =
    CALCULATE (
        MIN ( 'SumFirstDayMonth'[Date] ),
        FILTER ( ALL ( SumFirstDayMonth ), 'SumFirstDayMonth'[Status] = "Actual Month" )
    )
RETURN
    CALCULATE (
        SUM ( SumFirstDayMonth[Amount] ),
        FILTER ( ALL ( SumFirstDayMonth ), 'SumFirstDayMonth'[Date] = _first )
)

My visualization looks like this:

Is the result what you want? If not, please upload some data samples and expected output.

Please do mask sensitive data before uploading.

 

Best Regards,

Eyelyn Qin

erhan_79's avatar
erhan_79
Post Prodigy
6 years ago

Thank you very much Anonymous  ;

 

it is working perfect