Forum Discussion
Community ChampionPrevious year calculations bring back current year values :/ - help
Community Championthat definitely shifted something however my measures are behaving different, rushing off to a weekend away will figure it out monday, thanks for the help!
Community Supportvanessafvg Is the issue solved now?
- vanessafvg
no :( trying a variety of things but its just not working - i really can't figure out what i am doing wrong, just throwing in things now to see what i might be doing wrong.
Revenue = (CALCULATE(Sum(Registrations[MRR])) + CALCULATE(sum(Sales[RevenueNettAmount]))) - this is the base calculation
PY Revenue = CALCULATE([Revenue], SAMEPERIODLASTYEAR('Fiscal Date'[TheDate].[Date]), ALL('Fiscal Date') )
PY 2 = CALCULATE([Revenue], SAMEPERIODLASTYEAR('Fiscal Date'[TheDate].[Date]), 'Fiscal Date'[Calendar Year] )
PY 3 = CALCULATE([Revenue], PARALLELPERIOD(all('Fiscal Date'[TheDate].[Date]), -1, YEAR))
I do have a filter on the page which is only looking at the current fiscal year, but there is definitely data in my model that stretches back beyond the fiscal year which i thought the ALL would resolve. It does resolve it in PY Revenue however it doens't bring it back per day it just flat lines it in one aggregaton for all time.
Dont know if this makes sense?
MalSResolver III
I remember this problem from your other thread. I think this must be related to the relationships you have set up.
Can you share the .pbix file (or en extract from it?). Without that it's hard to troubleshoot.
- vanessafvg
no unfortunately i can't. but i can tell you that i have 2 fact tables (if you look at the revenue measure its the combination of a measure from these 2 facts), both fact tables have a single many to one relationship with the date in fiscal date