Forum Discussion

danidicky's avatar
danidicky
New Member
2 years ago
Solved

Convert Calculated Column to DAX measure

Hi all,

can you help me to convert a Calculated Column to DAX measure ?

This is the model:

 and this is the calculated coloumn:

I would convert to measure...

 

Thanks

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi danidicky ,

    Please try below dax formula:

    Da_produrre =
SUMX (
    Articoli,
    IF (
        [Speciale] = 1,
        IF ( RELATED ( VISART[Effettiva] ) < 0, - RELATED ( VISART[Effettiva] ), 0 ),
        IF (
            ( DIVIDE ( [Bad Dinamico], 240 ) * 30 )
                - RELATED ( VISART[Effettiva] ) <= 0,
            0,
            CEILING (
                ( DIVIDE ( [Bad Dinamico], 240 ) * 30 )
                    - RELATED ( VISART[Effettiva] ),
                [Pz_Pallet]
            )
        )
    )
)

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi danidicky ,

    Please try below dax formula:

    Da_produrre =
SUMX (
    Articoli,
    IF (
        [Speciale] = 1,
        IF ( RELATED ( VISART[Effettiva] ) < 0, - RELATED ( VISART[Effettiva] ), 0 ),
        IF (
            ( DIVIDE ( [Bad Dinamico], 240 ) * 30 )
                - RELATED ( VISART[Effettiva] ) <= 0,
            0,
            CEILING (
                ( DIVIDE ( [Bad Dinamico], 240 ) * 30 )
                    - RELATED ( VISART[Effettiva] ),
                [Pz_Pallet]
            )
        )
    )
)

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.