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.
Is it possible to enter rows in the query editor and enter in data manually? In the graphic below, I'm looking to take the value of 83500 and spread it among 12 months. The source data has the 83500, but we would like to allocate it evenly. However, it should only be done for this one column.
Solved! Go to Solution.
Hi
You could use the Fill Down transformation and divide the figure with 12
br
Erik
Hi
You could use the Fill Down transformation and divide the figure with 12
br
Erik
Where is the fill down transformation? Sorry have not seen this!
Hi Rsanjuan
Its on the transform tab
/Erik
Now do you always want this to be divided by 12 always or the number of months you have filtered?
always divided by 12 for this one column. The person is one of many, but she's the only one that needs to have this done. Thanks!
You can do a calculated measure that sums all of the row values.
CALCULATE(SUM(Value),ALL(TableName))/12
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |