Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All.
Very new to all this and am struggling to work out how I go about changing a column data by dividng it by a fixed number. I have a set of data from the source that has come in as bytes and I want to change this to GBytes. I cant change it on the source so haev to do it in BI
any pointers greatfully received.
Thank you
Solved! Go to Solution.
In Power Query (Query Editor), you can use the standard math functions to create a step that divides the column on import. If you do not do it on import, you create a custom column or measure and put in a formula like:
Column = DIVIDE([Column],1000000)
In Power Query (Query Editor), you can use the standard math functions to create a step that divides the column on import. If you do not do it on import, you create a custom column or measure and put in a formula like:
Column = DIVIDE([Column],1000000)
Hi smoupre
Thanks for the tip. I found it yesterday as it happens, think I couldt see the wood for the trees.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |