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.

Frequent Visitor

## Revenues from 3 different years in only one measure

Hello everyone,

I would like to be able to create a single metric that would allow me to have the revenue for this year, the year N-1, and the year N-2. Is this possible?

1 ACCEPTED SOLUTION
Super User

@Keks

Use one of the following Measures:

``````Three Year Revenue =
CALCULATE(
[Sales Amount],
DATESINPERIOD( 'Date'[Date] , DATE( YEAR( TODAY() ) , 12 , 31 ) , -3 , YEAR )
)``````

``````Three Year Revenue =
CALCULATE(
[Sales Amount],
DATESINPERIOD( 'Date'[Date] , DATE( YEAR( MAX('Date'[Date] )) , 12 , 31 ) , -3 , YEAR )
)``````
Did I answer your question? Mark my post as a solution! and hit thumbs up
Super User

@Keks

Use one of the following Measures:

``````Three Year Revenue =
CALCULATE(
[Sales Amount],
DATESINPERIOD( 'Date'[Date] , DATE( YEAR( TODAY() ) , 12 , 31 ) , -3 , YEAR )
)``````

``````Three Year Revenue =
CALCULATE(
[Sales Amount],
DATESINPERIOD( 'Date'[Date] , DATE( YEAR( MAX('Date'[Date] )) , 12 , 31 ) , -3 , YEAR )
)``````
Did I answer your question? Mark my post as a solution! and hit thumbs up

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