DAX Fridays! #67: FIXED

[@Laxmanmane007]

HI ruth please make video on real time scenario where we can use fixed() function.

[@marcelo157films]

Very simple, but very effective! Thank you for share with us.

[@CurbalEN]

Thanks and have a great weekend :) /Ruth

[@radekou]

Interesting function, any real-world scenario that you came across where it could be used? Thanks

[@frankgovers8420]

Radek Ouhel ml. , yep, I also want to know, when to use this function

[@CurbalEN]

Hi Radek and Frank, This function was new to me too. I use the Number.ToText very often in Power Query, but haven't used it in DAX yet. From the top of my head, maybe to convert year and month numbers to text? Not sure really. Maybe somebody here has used it and can tell us. As soon as I find a real case; I will post it here. /Ruth

[@Victor-ol1lo]

Cool and simple function, also new to me. Thanks and have a nice weekend. As always - Thumbs Up !!

[@CurbalEN]

Thanks! Have a great weekend to you too :) Cheers 🥂 /Ruth

[@Laxmanmane007]

Hi ruth, nice video please share more videos of DAX..

[@CurbalEN]

How much time do you have? ;) m.kzbin.info/aero/PLDz00l_jz6zym_YP8ZW11o52niGfCP8pN /Ruth

[@Dev_Bartwal]

U r great Ruth 🌹

[@CurbalEN]

Thanks! 😊 Have a great weekend! /Ruth

[@Laxmanmane007]

please upload real time scenario for fixed function

[@rassten]

fixed2 = FIXED(Table2[værdi];1;1) gives me no thousands separator

[@CurbalEN]

Mmmmmm, why doesn’t it work for me? which version of Power bi do you have? /Ruth

[@rassten]

2.53.4954.481 64-bit (december 2017)

[@CurbalEN]

Maybe it is a January bug... let me know when you upgrade if you have time :) /Ruth

[@rassten]

I am sorry, but not still no bug in :2.54.4970.961 64-bit (januar 2018)

[@CurbalEN]

Thanks for checking! Mmmm then it has to be related with the regional settings. Do you mind telling me what you have? /Ruth