Display through put data on current date

Hi mrvamsidhar

The way that I would slove this is by first ensuring I have a date table created and used.

Then what I would do is to create a new column for your first requirement in the Query Editor. And in this column you could then calculate if it falls into the same period as you specified. If it does in this column I would then create it with a name of "Last 6 Months by Day" for the true portion and "Not Last 6 Months" for the false.

Again I would create another column in the Query Editor based on your second requirement, and go through a similar process.

Then you could use each of those columns in a slicer to show the data you require?

Hi mrvamsidhar,

In addition, you can also use DAX to add two calculate columns to indicate if the sale date is current date or falls into Date Between Day 1 and Current Date, then use them as Slicers in your report to get your expected result. The formulas below are for your reference. :smileyhappy:

Date Between Day 1 and Current Date =
IF (
    DAY ( Sales[Date] ) <= DAY ( TODAY () ),
    "Date Between Day 1 and Current Date",
    "Others"
)

Current Date = IF ( DAY ( Sales[Date] ) = DAY ( TODAY () ), "Current Date", "Others" )

Regards