Show orders from past n days in Power BI

Question

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

Answer 1

HI banu,

Create a column like below,

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

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

Now add the days column in slicer and select last 30 days.

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

Hope this helps you.