Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I am trying to display an indicator in column "Rolling 18 Months", so I can filter sales by rolling 18 months. Below is the formula I tried without success. I want it to display "true" when the date is within the 18 month window and "false" when it is not. Any help is appriciated, thank you!
Solved! Go to Solution.
@jkal4712 , You are creating a column, No need for Max. The column need to be created in OpCo Purchases Query (SEED) table
Rolling 18 Months =
VAR EndDate =
EOMONTH(Today(), -1 )
VAR StartDate =
EDATE(EOMONTH(TODAY(), -1 ), -18 ) + 1
RETURN
IF(
( 'OpCo Purchases Query (SEED)'[day_dt]) >= StartDate
&& ('OpCo Purchases Query (SEED)'[day_dt] ) <= EndDate,
TRUE (),
FALSE ()
)
@jkal4712 , You are creating a column, No need for Max. The column need to be created in OpCo Purchases Query (SEED) table
Rolling 18 Months =
VAR EndDate =
EOMONTH(Today(), -1 )
VAR StartDate =
EDATE(EOMONTH(TODAY(), -1 ), -18 ) + 1
RETURN
IF(
( 'OpCo Purchases Query (SEED)'[day_dt]) >= StartDate
&& ('OpCo Purchases Query (SEED)'[day_dt] ) <= EndDate,
TRUE (),
FALSE ()
)
Thank you so much that worked perfectly!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.