Power BI – Value should be a Currency

-> I was trying to create a new conditional column called “Price Tier” in Power BI based on a Currency column called Price. I got below message,

Value should be a Currency.

-> I couldn’t get much from the internet for this issue.

-> I ended up changing the currency column “Price” to decimal and then created the new conditional column “Price Tier”.

-> Once the new Conditional Column “Price Tier” was created. I changed “Price” back to Currency from Decimal.

-> Not sure if this is a bug, but the workaround actually worked for me.

Thank You,
Vivek Janakiraman

The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s