Forum Discussion

gmsamborn's avatar
gmsamborn
Super User
2 years ago
Solved

Uncommon year-ends

After looking at a fiscal-year problem earlier today, I was reminded of a old client that had a year-end of Jan-31.   DATESYTD() can handle that.  Because DATESQTD() doesn't have an additional para...
Need Help
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    2 years ago

    gmsamborn 

    Yes, you are right. only  TOTALYTD and DATESYTD support YearEnd parameter. Other related period functions will have to be made using custom DAX.

Fowmy's avatar
Fowmy
Super User
2 years ago

gmsamborn 

Yes, you are right. only  TOTALYTD and DATESYTD support YearEnd parameter. Other related period functions will have to be made using custom DAX.

gmsamborn's avatar
gmsamborn
Super User
2 years ago

Thanks Fowmy 

That's what I thought.

With a date table with fiscal year, quarter and period, it shouldn't be too hard.

 

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    gmsamborn 

    Let me know if you need any help in building such measures.

    You share sample data and the expected result