Forum Discussion
amikm
Helper V
Helper VIssue with Date during closed year
I have a table that has all the dates from 01/01/2020 to 31/12/2020 I am writing a DAX measure to calculate Sales based on dates Sales=CALCULATE(SUM(Sales[Sale]), FILTER(Sales,Sales[CYPY]="CY")) ...
parry2k
Super User
Super Useramikm I have a post which talks about delayed month end, you can take the similar approach delayed year-end or you can build the logic for CY that in Feb it take the current year as CY otherwise it should take the previous year as CY.