Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 s...
General Comment
Interesting Links
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    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.

Arul's avatar
Arul
Super User
3 years ago

Anonymous ,

Do you have that date anywhere in your data model?

Thanks,

Arul