Last 30 Days in all months

[qwaiti27231]

i need a measure to calculate last 30 days in all months

month 1 -30 days data

month 2-30 days   data

[Ashish_Mathur]

Hi,

If today is 26 October 2020, then what do you mean by last 30 days?  Likewise on 29 February 2020, what would last 30 days be?  Please clarify.  

[Ashish_Mathur]

Hi,

And what do you do in February?

[qwaiti27231]

if it has 28 or 29 days data then it shows anyway 

[amitchandak · Accepted solution]

@qwaiti27231 , Try measure like

Rolling 30 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],eomonth(Sales[Sales Date],0),-30,DAY))
Rolling 30 last month = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],eomonth(Sales[Sales Date],-1),-30,DAY))

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.

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[qwaiti27231]

@amitchandak it doesnt work for feb and the current month 

[qwaiti27231]

i need to use only one date