Forum Discussion

djh's avatar
djh
Frequent Visitor
8 years ago

Filter table date

Hi,   i'm wanting to create some measures to work out customer retention. I want to look at data within certain date ranges, and apply a measure to my table, but only using the most recent month of...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi djh 

 

Could you please post some sample data with expected output? That will help us to help you.

 

By going through your post, am guessing that you want to create a measure for last month data. So, for example, you want to create sum of sales for the last month data, then the below one will help you.

 

CALCULATE(SUM(Sales_Fact.Sales),DATEADD(Dates[Date],-1,MONTH)

 

Hope this helps. Please share more details, if you need further info.

 

Thanks
Raj