Create a automated daily rate

[PSRai]

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?

[v-yuta-msft]

@PSRai ,

Could you please share the formatted expected table and clarify more details about the your requirement?

Regards,

Jimmy Tao

[PSRai]

@v-yuta-msft 

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

[v-yuta-msft]

@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

[PSRai]

Hi @v-yuta-msft 

I have the following columns,

Contract No, 

Hire date

End date 

Total Rate

Contract No - 00001

Hire date - 01/01/2019

End date - 11/01/2019

Total Rate - 125.73

Outcome =  Divide Total Rate and apply by number of days contract is live

=125.73/11 = 11:43

Output

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.43            11.43           11.43            11.43            11.43            11.43           11.43            11.43            11.43            11.43

11/01/2019

11.43

There are many contracts with different hire dates, end dates and total rates.  

[amitchandak]

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 Linkedin

[PSRai]

@amitchandak 

Unfortunately that wouldn't work as there can be thousands of rows of data and more data can be added on a daily basis.