Forum Discussion
Solved
Custom column for report using Power BI Dataset
I'm trying to create a report in Power BI Desktop using a Power BI Dataset sitting in a workspace. I want to customise some values for a report showing animal data. Specifically, for the column "Cu...
SBDEV You can only do measures (not columns) in live query mode (which is how you connect to Power BI Datasets).
You could try a new MEASURE:
New Animal Type = IF(SELECTEDVALUE'Animal'[Current Animal Type]) IN {"Cat", "Kitten"}, "Feline", SELECTEDVALUE('Animal'[Current Animal Type]))
SBDEV You can only do measures (not columns) in live query mode (which is how you connect to Power BI Datasets).
You could try a new MEASURE:
New Animal Type = IF(SELECTEDVALUE'Animal'[Current Animal Type]) IN {"Cat", "Kitten"}, "Feline", SELECTEDVALUE('Animal'[Current Animal Type]))
Awesome!! Thank you, AllisonKennedy. That worked!
You're welcome. Glad to help. 🙂