Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Previous Period using Calendar

I have a simple formula that worked in another file but doesn't seem to work in my current one. The same formula works in one workbook but not the other and im scratching my head on why it isn't work...
Need Help
  • ajaybabuinturi's avatar
    ajaybabuinturi
    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.

ajaybabuinturi's avatar
ajaybabuinturi
Super User
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Interesting interaction, thank you for the help.