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

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

Reply
KMadsen
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
johnt75
Super User
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 ()
    )

View solution in original post

2 REPLIES 2
daXtreme
Solution Sage
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.

johnt75
Super User
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 ()
    )

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.