The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello - I need to create a DAX expression which captures a string (highlighted red below), but doesn't actually use double quotation marks. Is there a way i can do this? (example of hypothetical solution - populationNY = .... , Geography[State] =String(NY))
Solved! Go to Solution.
Found the answer - I wasn't properly escaping the double quotes when converting the file which contained my request body to a Json file. PBI accepted the request after fixing it
Why do you need this?
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
I'm using the Rest API to post a dataset that includes calculated fields. They key-value pairs for the measures are throwing back errors since the quotes in the DAX expressions are being interprated as the end of the value
Found the answer - I wasn't properly escaping the double quotes when converting the file which contained my request body to a Json file. PBI accepted the request after fixing it
User | Count |
---|---|
10 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
21 | |
14 | |
14 | |
9 | |
7 |