Skip to main content

    Power BI

    Needs Votes

    TOTALFY

    Vote (3) Share
    Darek's profile image

    Darek on 11 Oct 2017 20:31:12

    In almost all of our dashboards we are showing MTD, YTD and FY (full year) figures. Please add similar formula to TOTALMTD or TOTALYTD to be able to present full year figures easily.

    Comments (1)
    Darek's profile image Profile Picture

    Cidcley Barbosa on 05 Jul 2020 23:30:13

    RE: TOTALFY

    Darek, I did it using ENDOFYEAR:

    FY:=TOTALYTD([Values];ENDOFYEAR(Calendar[Date]))