Show orders from past n months

Question

How to show orders from past n months in Power BI?

Answer 1

Hi banu,

Create a column like below,

diff = DATEDIFF(Orders[Order Date].[Date],TODAY(),MONTH)

days = IF(Orders[diff] < 4 ,"last 4 months","past orders")

Now add the days column in slicer and select last 4 months.

Add other required fields to show data for last n months.

Hope this helps you.