Dynamic Formatting Error

Hi tom-lenzmeier , I just modified the DAX formula you were using and obtained the following result. Can you let me know if this is what you are looking for?

The issue with the sum on the date was causing an overflow error, so I took the maximum value and added it to the date to resolve the problem.

Display Value Fixed = 
VAR _AttrType = SELECTEDVALUE(UP_PRD_Agreements[Attribute])
VAR _Raw      = SUM(UP_PRD_Agreements[Value])
VAR _RawMax   = MAX(UP_PRD_Agreements[Value])

RETURN
SWITCH(
    _AttrType,

    "EffectiveDate",
        FORMAT(
            DATE(1899, 12, 30) + INT(_RawMax),
            "MM/dd/yyyy"
        ),

    "Current Price",
        FORMAT(_Raw, "$#,##0"),

    "Current Price Valid From",
        FORMAT(
            DATE(1899, 12, 30) + INT(_RawMax),
            "MM/dd/yyyy"
        ),

    FORMAT(_Raw, "0")
)

dax :

Fixed dax :

Sample file :
Dynamic Formatting.pbix

Thanks,
If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster