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

amitchandak's avatar
amitchandak
Super User
5 years ago

erhan_79 , One way with date table, cumulative till last month

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=maxx(date,dateadd(date[date]),-1,month)))

 

or last few months

Rolling 6 till last 1 month = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],ENDOFMONTH(dateadd(Sales[Sales Date],-1,month)),-6,MONTH))

 

and this month

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

  • erhan_79's avatar
    erhan_79
    Post Prodigy
    5 years ago

    dear amitchandak ;

     

    can you check below formula , could be something wrong ? , something is not working.