Forum Discussion
Previous Period using Calendar
- 1 year ago
Hi Anonymous,
I reviewed the BI report. What happend over there is used two different columns in your model, used Calendar Year column to the visual and Calendar YearNumber for DAX logic. Because of that your getting BLANK values in the visual. You can refer below snippets and make sure that both visual fields and DAX logic columns should be same.Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.
Hi Anonymous,
This should be work however could you please share some sample data which this DAX logic is not working. So that will try to provide the solution.
Here's the sample file
https://drive.google.com/file/d/1Og75GE4yJHWsJMeCqkAeecpLfafmswKx/view?usp=sharing