Quick Measure YoY%

[edavila]

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 

[MFelix]

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

[edavila]

Thank 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-msft]

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