manipulation of 'last' dates and 'previous ' dates

[mazwro]

I have a table like this in power BI. There is a client email and dates that this email transacted.

How can I get it to a format like this:

I need to figure out logic like this:

- client transacted in last 3 months

- client transacted in 3 months prior to last 3 month

I think two columns would do

[DatawithDinesh · Accepted solution]

You can create two columns, with the following dax, I'm assuming that date_order is the transaction date for the client email on which the calculation will be based on.

Last3Months = 
IF(
    [date_order] >= TODAY() - 90 && 
[date_order] <= TODAY(),
    1,
    0
)
_________________________________________________________________________


Prior3Months = 
IF(
    [date_order] >= TODAY() - 180 && [date_order] < TODAY() - 90,
    1,
    0
)