Solved: Re: Conditional select of unichar up and down arro...

anushavikram · ‎05-21-2019

Hi all,

I have to display unichar up and down arrows based on a measure.

My DAX is as follws

percentagedifference = IF([YTD difference]>=0, UNICHAR(9650), UNICHAR(9660))

Why is my output wrong.?

AkhilAshok · ‎05-26-2019

Looks like you have created percentagedifference as a Calculated Column instead of a Measure. Change it to a measure and it should work fine.

View solution in original post

AkhilAshok · ‎05-26-2019

Looks like you have created percentagedifference as a Calculated Column instead of a Measure. Change it to a measure and it should work fine.

anushavikram · ‎05-26-2019

@AkhilAshok

Thanks a lot mate. I cant believe i have made such an unnoticed silly mistake.

I was under an impression i made a measure.

parry2k · ‎05-22-2019

@anushavikram are you adding perecentagedifference as column or measure? It has to be a measure.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

anushavikram · ‎05-22-2019

Hi,

Its a measure.

YTD difference used in percentagedifference is a measure too which is built up on two other measures.

thisyearYTD sales and lastYearYTD sales.

Regards,

Anusha.

parry2k · ‎05-22-2019

@anushavikram weird, can you share pbix file with sample data, remove any sensitive information before sharing.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

anushavikram · ‎05-23-2019

@parry2k

Here is the link to the file. Kindly let me know if you are unable to access.

https://hotnz-my.sharepoint.com/:u:/g/personal/anusha_hot_co_nz/EZQsu4WrHsxMiEsCI2sORg8B_qKOv4Qe_11R...

parry2k · ‎05-23-2019

@anushavikram not able to download, it says to login with an account.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.