Below, I've included the video for our weekly challenge question. If you think you know the answer, feel free to respond here or on any of our social media platforms.
Below, I've included the video for our weekly challenge question. If you think you know the answer, feel free to respond here or on any of our social media platforms.
For some odd reason, I decided to look at this (must have been DAX that drew me in). Imagine my surprise when IU hit play and I heard Bob Dylan singing Desolation Row. Best Excel TV I have ever seen/heard (thanks Bob - the other Bob).
If anyone wants (an) answer, it is FORMAT (DAX) and TEXT(Excel).
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)