BKNewton29
New Member
- Joined
- Sep 17, 2010
- Messages
- 30
Hi,
I'm trying to create a measure that will return the annual income figure in every month of that year.
The current year is returning the numbers as I expected (see image below). However the prior year numbers are not working as planned and are only returning the totals of the numbers that are sat in the same months as the current year.
The two measures created are as below. I suspect the issue is realted to the measure only returning months that exist in the current year. Any help would be appreciated.
FX Renewable Income Annual PY
=SUMX(values('Table Data'[ContRef|CommProd]),
CALCULATE([FX Renewable Income],PREVIOUSYEAR('Calendar'[Date]),
ALLSELECTED('Calendar'[Year])-1,
ALL('Calendar'[MonthNumberOfYear])))
FX Renewable Income Annual
=SUMX(values('Table Data'[ContRef|CommProd]),
CALCULATE([FX Renewable Income],
ALLSELECTED('Calendar'[Year]),
ALL('Calendar'[MonthNumberOfYear])))
I'm trying to create a measure that will return the annual income figure in every month of that year.
The current year is returning the numbers as I expected (see image below). However the prior year numbers are not working as planned and are only returning the totals of the numbers that are sat in the same months as the current year.
The two measures created are as below. I suspect the issue is realted to the measure only returning months that exist in the current year. Any help would be appreciated.
FX Renewable Income Annual PY
=SUMX(values('Table Data'[ContRef|CommProd]),
CALCULATE([FX Renewable Income],PREVIOUSYEAR('Calendar'[Date]),
ALLSELECTED('Calendar'[Year])-1,
ALL('Calendar'[MonthNumberOfYear])))
FX Renewable Income Annual
=SUMX(values('Table Data'[ContRef|CommProd]),
CALCULATE([FX Renewable Income],
ALLSELECTED('Calendar'[Year]),
ALL('Calendar'[MonthNumberOfYear])))