Forum Discussion
Data Format Issue when connecting Smartsheet with Power BI
Hi 117325
You could go to Edit queries, create a conditional column
Then change its type to "Number"(whole number or decimal number as you like)
Apply &close, go to report view, you could create a measure as i provide before to show the currency format.
Measure 2 = FORMAT( MAX('Sheet2$'[spend]), "Currency")You could download my pbix to see more details.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the solution. Maggie. I was able to pull the format for the whole number. However, there is an issue with the currency format as the current cost column is in a text value with mixed currency value and text with "TBD". Any way we can change the existing text value column in currency format ($) - only to the currency value cells.
Adding screenshot of the cost column with the mixed values
Hi 117325
You could go to Edit queries, create a conditional column
Then change its type to "Number"(whole number or decimal number as you like)
Apply &close, go to report view, you could create a measure as i provide before to show the currency format.
Measure 2 = FORMAT( MAX('Sheet2$'[spend]), "Currency")You could download my pbix to see more details.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi 117325
Is this problem sloved?
If not, please let me know.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Yes, the solution worked. Thanks a lot!