Forum Discussion

gmsamborn's avatar
gmsamborn
Icon for Super User rankSuper 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
Icon for Super User rankSuper 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
    Icon for Super User rankSuper 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
      Icon for Super User rankSuper 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