Function DATED expects a contiguous selection When the date column is not unique, has gaps or it con

[chilenitaaa]

'MdxScript(Model) (3,70) Function DATED expects a contiguous selection When the date column is not unique, has gaps or it conteins time portions."

Hi, pls, I need help to resolve this issue.

Im doing a LY comparition, and i create a measure with dax 

PRIMA_COM LY = CALCULATE(SUM(base2[PRIMA_COM]),DATEADD('Date Dimension'[FCHEMISION],-1,YEAR))

It function well if I put in a table de measure, the PRIMA_COM to compare, and the date, from a dimension table that previously had created.

If I filter by page or by the visual for "month" i get the error message.  Even if I use the dimension date or the date from the table data its the same result.. 

what can I do? I need to show for just a few months the data, not everithing

 

[chilenitaaa]

thank you!, I'll see those links.
I already make I don't know how many things to make it work, one of those did it!, but I don't know which one.. 😅

[Greg_Deckler]

@chilenitaaa You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...