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

Question

'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

greg_deckler · Answer

chilenitaaa&nbsp;You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000Also, 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-TITHW/m-p/434008

chilenitaaa · Answer

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..&nbsp;😅&nbsp;

Forum Discussion

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

2 Replies

Related content

Function 'SAMEPERIODLASTYEAR' expects a contiguous selection Issue

Function selection

Previous Year measure - Function Dateadd expects a Contiguous Selection

What is contiguous selection?

Function 'DATEADD' only works with contiguous date selections.