Forum Discussion
Create a automated daily rate
Hi,
Is there a way I can autopopulate figures into each date using a start and end date. Below is a example I need to replicate. I need to create a daily rate.
Start date End date Total Rate 01/01/2019, 02/01/2019, 03/01/2019, 04/01/2019, 05/01/2019,06/01/2019,07/01/2019
01/01/2019 10/01/2019 £1000 £100 £100 £100 £100 £100 £100 £100
01/01/2019 05/01/2019 £100 £20 £20 £20 £20 £20
02/01/2019 05/01/2019 £500 £125 £125 £125 £125
Each row will have a contract number but that can be duplicated as 1 contract can have many row values
Is this possible?
6 Replies
Create a new column of measure and give value whare ever you want nad use that
new column =100
new measure =100
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on LinkedinUnfortunately that wouldn't work as there can be thousands of rows of data and more data can be added on a daily basis.
PSRai ,
Could you please share the formatted expected table and clarify more details about the your requirement?
Regards,
Jimmy Tao
This is the desired outcome. Each contract has a total rate. I need to divide the total rate by the number of days the contract is live and apply that to each day its live. as example below
01/01/2019 02/01/2019 03/01/2019 04/01/2019 05/01/2019 06/01/2019 07/01/2019 08/01/2019 09/01/2019 10/01/2019 11/01/2019 11.43 11.43 11.43 11.43 11.43 11.43 11.43 11.43 11.43 11.43 11.43 14.59 14.59 14.59 14.59 14.59 14.59 14.59 1.86 1.86 1.86 1.86 1.86 1.86 1.86 1.86 1.86 1.86 6.43 6.43 6.43 6.43 6.43 6.43 6.43 6.43 6.43 6.43 5 5 5 5 5 5 5 5 5 5 1.29 1.29 1.29 1.29 1.29 1.29 1.29 1.29 1.29 1.29 4 4 4 4 4 4 4 4 4 8.28 8.28 8.28 8.28 8.28 8.28 8.28 2.14 2.14 2.14 2.14 2.14 2.14 2.14 153.52 153.52 153.52 153.52 153.52 153.52 153.52 20 20 20 20 20 20 20 20 20 0 0 0 0 0 0 0 0 0 4.28 4.28 4.28 4.28 4.28 4.28 4.28 4.28 4.28 1.43 1.43 1.43 1.43 1.43 1.43 1.43 1.43 1.43 2 2 2 2 2 2 2 2 2 34.27 34.27 34.27 34.27 34.27 34.27 34.27 34.27 34.27 3.42 3.42 3.42 3.42 3.42 3.42 3.42 3.42 3.42 49.98 49.98 49.98 49.98 49.98 49.98 49.98 49.98 49.98 0 0 0 0 0 0 0 0 0 94.84 94.84 94.84 94.84 94.84 10.09 10.09 10.09 10.09 10.09 10.09 10.09 10.09 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 2.86 2.86 2.86 2.86 2.86 2.86 2.86 2.86 15.71 15.71 15.71 15.71 15.71 15.71 15.71 15.71 3.42 3.42 3.42 3.42 3.42 3.42 3.42 3.42 PSRai ,
This is the desired outcome. Each contract has a total rate. I need to divide the total rate by the number of days the contract is live and apply that to each day its live
Your requirement is not so clear. Could you please show the logic expression and give the expected result?
Regards,
Jimmy Tao
