Forum Discussion
Tabular Editor: Non-Standard Calendar time comparisons/Conditional calculation with filters
Hi All, I am looking to transition from creating redundant time comparison measures (that require a lot of copy and pasting for measure creation) to utilizing tabular editor. A couple of ca...
You may need to adjust the filters for your period definition.
Can you provide a screenshot of your calendar table to understand the mechanic behind it and explain in more detail what is the expected output from the calculation?
It is not an issue with the calendar or time portion, as the formula stemmed from a summation of the L13wks (which I validated before adding to the dax to apply the conditional filter).
I recommend you troubleshoot it piece by piece. You can create two additional calculations to pull only the Selected measure and another one for COUNTROWS just to validate what they are returning.
Are all your measures additive or do you have more complex definitions on your measures?