Hi,
1)I need to show data previous Every month first- and second-day data and last two days data.
2)Current month first- and second-day data and current day data I need.
I have done manually but i need dynamically.
Please help me.
You can use the following to get the values:
IF [Order Date]<=DATEADD('day',1,(DATETRUNC('month',[Order Date])))
OR DATEPART('day',[Order Date])>=DATEPART('day',DATEADD('day',2,[Order Date])) THEN [Sales]
ELSEIF [Order Date]=TODAY() THEN [Sales]
END
If you also need that to be a filter to display just those values you could use the following on the Filters Card:
[Order Date]<=DATEADD('day',1,(DATETRUNC('month',[Order Date])))
OR DATEPART('day',[Order Date])>=DATEPART('day',DATEADD('day',2,[Order Date]))
OR[Order Date]=TODAY()
Set to TRUE:
Best, Don
(Please, don't forget to click Select as Best or Upvote !)
