cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

## Apply time period to IF measure

Hi All,

I have an exisitng measure that works well - it is based on a number of "IF" statement and in the end calculates the accuracy of a forecast.

Forecast accuracy Consensus = if(sum('Region consolidated data'[Total demand])=0 && sum('Region consolidated data'[ABS deviation consensus])<>0,0,if(1-DIVIDE(

SUM('Region consolidated data'[ABS deviation consensus]),
SUM('Region consolidated data'[Total demand])
)<0,0,1-divide(sum('Region consolidated data'[ABS deviation consensus]),sum('Region consolidated data'[Total demand]))))

I can filter the data to only show the last 3 months, 6 months etc. through the date slicer.

However, I would also like to have a "static" measure for the last 3 month, 6 months and 12 months to be able to show these side by side in a table.

Can anyone advise on how I can create "new" measures based on above but limited to the mentioned time periods?

Thanks!

1 ACCEPTED SOLUTION
Super User

You could create a calculation group with calculation items for each period you want to show, e.g.

``````3 months =
VAR StartDate =
EOMONTH ( TODAY (), -4 ) + 1
RETURN
CALCULATE (
SELECTEDMEASURE (),
'Date'[Date] >= StartDate
&& 'Date'[Date] <= TODAY ()
)
``````
2 REPLIES 2
Solution Sage

You should ditch your IF's in favour of SWITCH. Second, creating a 'static' measure is simple - use the right filters on your existing measures.

Super User

You could create a calculation group with calculation items for each period you want to show, e.g.

``````3 months =
VAR StartDate =
EOMONTH ( TODAY (), -4 ) + 1
RETURN
CALCULATE (
SELECTEDMEASURE (),
'Date'[Date] >= StartDate
&& 'Date'[Date] <= TODAY ()
)
``````

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors