Previous Period using Calendar

[tqn3728]

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 working.

PY $ = VAR Previous = SELECTEDVALUE('Date Table'[Calendar YearWeekNumber])-1
RETURN
CALCULATE(
    [Gross Sales],
    'Date Table'[Calendar YearWeekNumber]=Previous)

[ajaybabuinturi · Accepted solution]

Hi @tqn3728,
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.

[tqn3728]

Interesting interaction, thank you for the help.

[ajaybabuinturi]

Hi @tqn3728,
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. 

[tqn3728]

Here's the sample file
https://drive.google.com/file/d/1Og75GE4yJHWsJMeCqkAeecpLfafmswKx/view?usp=sharing