Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
100 | |
83 | |
76 | |
65 |
User | Count |
---|---|
120 | |
108 | |
98 | |
83 | |
77 |