Skip to main content

    Power BI

    Needs Votes

    Define query calculation items in calculation groups

    Vote (43) Share
    Marco Russo's profile image

    Marco Russo on 07 Apr 2021 21:06:34

    Enable a syntax to define/replace a calculation item of a calculation group in a DAX query.

    DEFINE
    CALCULATIONITEM 'Time Intelligence'[Time Calc]."YTD" =
    CALCULATE ( SELECTEDMEASURE(), DATESYTD ( DimDate[Date] ) )

    Comments (2)
    Marco Russo's profile image Profile Picture

    Jaouad Safouani on 09 Apr 2021 08:50:53

    RE: Define query calculation items in calculation groups

    Thanks Marco, this is a great enhancement 💡.

    Marco Russo's profile image Profile Picture

    Pär Adeen on 08 Apr 2021 19:56:20

    RE: Define query calculation items in calculation groups

    Thanks for creating Marco. And while re-defining the calculation item is the most needed, also defining/changing a calculation group would be nice, but this shall not delay the implementation of this request