Skip to main content

    Power BI

    New

    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

    2e841555 7209-417d-a276-8be77daea3fb on 05 Jul 2020 23:30:13

    RE: TOTALFY

    Darek, I did it using ENDOFYEAR:

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