cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Helper I

## DAX measures

Hello everybody,
i need help on calculating 2 measures in power BI.

I have a table with 2 columns:
1 - invoice_date
2 - provided

in the invoice_date column there are dates of 2021 and 2022.
(e.g. 01/02/2021, 05/03/2021, 07/08/2022, 22/12/2022 ...)

I have to create a measure that calculates the provided only for the dates of the previous year (2021) in an absolute way, in the sense that over time the previous year will become 2022 etc ...

Then I have to create a second measure that calculates the provided only for the dates of the current year (2022) here too in an absolute way.

What are the dax formulas that i have to use for these 2 measures?

Erika

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Try this

test CY = CALCULATEsum('sample'[something]), YEAR('sample'[date]) = YEAR(TODAY()))
test PY = CALCULATE( sum('sample'[something]), YEAR('sample'[date]) = YEAR(TODAY())-1)
3 REPLIES 3
Anonymous
Not applicable

Try this

test CY = CALCULATEsum('sample'[something]), YEAR('sample'[date]) = YEAR(TODAY()))
test PY = CALCULATE( sum('sample'[something]), YEAR('sample'[date]) = YEAR(TODAY())-1)
Helper I

if I wanted to also calculate the provided of the current month, in an absolute way?
How can I do?

Helper I

thank you! it works!

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

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

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors