The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to 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
)
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
)