Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Kilograms to Tons

Dear All, I am new to power bi. I want to create one meaure. I have sales in Kilograms. I am trying to convert it into Tons through a meaure, but not able to do it.   Can you please help. DIVIDE('...
  • AlB's avatar
    AlB
    6 years ago

    Hi Anonymous 

    Try

    DIVIDE( SELECTEDVALUE( 'New sheet Rayees'[Standard Qty]) ,1000)

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

Try

DIVIDE( SELECTEDVALUE( 'New sheet Rayees'[Standard Qty]) ,1000)

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers