Forum Discussion
Solved
Data Format Issue when connecting Smartsheet with Power BI
Our team is working on a dashboard with data directly connected to Smartsheet Data. We have correct data formats on the Smartsheet data source (i.e. whole number with no decimal point, $ for currency...
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!