Direct Query - DAX function issue (SamePeriodLastYear)

[omarpiceno92]

Hi, 

I accessing data through Direct Query. While using SamePeriodLastYear function in some measures, I am trying to slice data monthly as well. However, the following error message is displayed in my visualizations while adding a Month slicer:

MdxScript(Model) (56, 124) Calculation error in measure 'General Ledger Activities'[GL Amount PY]: Function 'SAMEPERIODLASTYEAR' expects a contiguous selection when the date column is not unique, has gaps or it contains time portion.

My DAX formula for GL Amount PY is the following: 

GL Amount PY = CALCULATE('General Ledger Activities'[GL Amount],All('Fiscal Calendars'), SAMEPERIODLASTYEAR('Fiscal Calendars'[Date]))

It would be greatly appreciate if someone can help me solve this issue. 

Bests,

Omar

[v-piga-msft]

Hi @omarpiceno92,

I also agree with Ross73312. Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share some data sample which could reproduce your scenario.

Best  Regards,

Cherry

[Anonymous]

Is your fincial calenders a true date table?  Does it have 1 row for each date?

If not, i'd suggest creating a full date table.  This can be done fairly simply using either Power Query or DAX.  A quick google search will turn up a few methods you can usually just copy and paste into your project.