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 parameter for year-end ("01/31"), does that mean every QTD-related calculation would have to be "hand written" ?

 

I'm only asking because even though it might be uncommon for a year-end but behind December, April, July and October, it is generally the next most common.

 

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.

3 Replies

  • 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