Forum Discussion
Dynamic date period
I am trying to check if an appraisal was completed withing the appraisal period. This should be dynamic as appraisal period changes for each year. I think an IF statement would be fine but i am not sure how to make my date to cover different years.
what i have is:
IF('Appraisal Date'[Date] > 01/06/2022, 1, 0)
Is it possible to have 01/06/2022 change dynamically for each appraisal year?
Hi,
Create a Calendar Table and write these calculated column formulas
Month name = format(calendar[Date],"mmmm")
Month number = month(calendar[date])
Appraisal year = if(calendar[month number]<=6,year(calendar[date])-1&" "&year(calendar[date]),year(calendar[date])&" "&year(calendar[date])+1)
Hope this helps.
7 Replies
Anonymous ,
Do you have that date anywhere in your data model?
Thanks,
Arul
Anonymous ,
So, you don't want to change it everytime in the measure in PBI but you want the date needs to be changed dynamically.
Thanks,
Arul
