Forum Discussion
Helper IIQuick Measure YoY%
Hello Community
I seeking for help as I have a formula that is not working correctly
I had the same formula with another table and it was working correctly but I remapped and everything is the same just rename the fields and change it as well on formula but it just showing no relation to a something and I can't figure out as everything for me is the same
this is the error
Error Message:
MdxScript(Model) (92, 5) Calculation error in measure 'FACT_TransactionCharge'[$ Revenue YoY%]: Function 'SAMEPERIODLASTYEAR' expects a contiguous selection when the date column comes from a table on the 1-side of a bi-directional relationship.
I don't understand what this means
can someone please help me
Thanks
3 Replies
- MFelix
Super User
Hi edavila ,
What this error means is that the column you are using on the measure to calculate the SAMEPERIODLASTYEAR is coming from a table that doesn't have continuous dates.
Are you using a calendar table to make the calculation or only a column with fact data?
You need to have a column that starts on january 1st and ends on 31st December, this need to be within several years period.
Regards,
MFelix
edavilaThank you for your answer and yes the date calendar table I use a filter that is “after 12/31/2015” is this wrong
v-juanli-msftCommunity Support
Hi edavila
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
Best Regards
Maggie
