Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
5 years ago
Solved

Measure Help

Hi there;   I need your little help, I have a table like as below I need to calculate with a measure only the sum of the amount of the current month and previous month For the below example , as y...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    erhan_79 

    Try below measure:

    Measure = 

CALCULATE(
    SUM(Table1[Amount]),
    FILTER( ALL(Table1[Date]) , 
        Table1[Date] <= EOMONTH(TODAY(),0)
    )
)

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

erhan_79  I'm not sure I understand your question - are you trying to find a cumulative sum of everything including this month and before? Do you have a DimDate table? You will need one with a Date data type column, and month column.

https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html

 

There are a few options here. You could filter this with a relative date slicer or use an explicit measure with filter inside the measure, such as: 

 

AmountToDate =

CALCULATE(SUM(Table[Amount]), MONTH(DimDate[Date]) <= MONTH(TODAY()) && YEAR(DimDate[Date]) = YEAR(TODAY()) )

 

 

  • erhan_79's avatar
    erhan_79
    Post Prodigy
    5 years ago

    dear AllisonKennedy  ;

     

    i dont have dim dat table , i am working on a live data so i can not create dim date .Is not possible to solve without Dimdate ?

     

    yes ı am  trying to find a cumulative sum of everything including this month and before

     

    thanks 

     

     

    • AllisonKennedy's avatar
      AllisonKennedy
      Community Champion
      5 years ago

      erhan_79 , Yes it is possible without date table, just use the Date column from your table instead of DimDate table. Note my solution assumes you only want data from this year. See the solution from Fowmy  for a more elegant solution if you want ALL data from all previous years up to this month.