Skip to main content

    Power BI

    Needs Votes

    Year End Support for DATESQTD, TOTALQTD

    Vote (37) Share
    Amit Chandak's profile image

    Amit Chandak on 22 Feb 2020 23:49:59

    Support for custom Quarter, Datesqtd,totalqtd should also have a year-end date. Just like Datesytd and totalytd year end support should be, It will handle cased when Quarter ends other than march , jun, sep and Dec.

    Comments (4)
    Amit Chandak's profile image Profile Picture

    Rashmi Gopala on 09 Oct 2023 07:50:48

    RE: Year End Support for DATESQTD, TOTALQTD

    Hi can Power BI come up with Solution for QTD and Total QTD with customized Financial Year end as it is available for YTD. It takes a lot of effort to arrive at this which could have a simple solution.

    Amit Chandak's profile image Profile Picture

    Delfina Alvarez on 01 Nov 2022 20:32:21

    RE: Year End Support for DATESQTD, TOTALQTD

    QTD = TOTALQTD(VENTAS, DATESQTD(DATE, YEARENDDATE)

    Amit Chandak's profile image Profile Picture

    Delfina Alvarez on 16 Jun 2022 17:55:45

    RE: Year End Support for DATESQTD, TOTALQTD

    Great idea. Finish date for QTD

    Amit Chandak's profile image Profile Picture

    Adrian Van Rensburg on 29 Apr 2022 09:06:51

    RE: Year End Support for DATESQTD, TOTALQTD

    Still no way to change your fiscal year dates?