Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
mazwro
Helper II
Helper II

manipulation of 'last' dates and 'previous ' dates

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

 

mazwro_0-1723542934287.png

 

1 ACCEPTED SOLUTION
DatawithDinesh
Resolver II
Resolver II

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
)

View solution in original post

1 REPLY 1
DatawithDinesh
Resolver II
Resolver II

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
)

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors