Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
PSRai
Helper III
Helper III

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 6
v-yuta-msft
Community Support
Community Support

@PSRai ,

 

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

 

Regards,

Jimmy Tao

@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/201902/01/201903/01/201904/01/201905/01/201906/01/201907/01/201908/01/201909/01/201910/01/201911/01/2019
11.4311.4311.4311.4311.4311.4311.4311.4311.4311.4311.43
 14.5914.5914.5914.5914.5914.5914.59   
 1.861.861.861.861.861.861.861.861.861.86
 6.436.436.436.436.436.436.436.436.436.43
 5555555555
 1.291.291.291.291.291.291.291.291.291.29
  444444444
  8.288.288.288.288.288.288.28  
  2.142.142.142.142.142.142.14  
  153.52153.52153.52153.52153.52153.52153.52  
  202020202020202020
  000000000
  4.284.284.284.284.284.284.284.284.28
  1.431.431.431.431.431.431.431.431.43
  222222222
  34.2734.2734.2734.2734.2734.2734.2734.2734.27
  3.423.423.423.423.423.423.423.423.42
  49.9849.9849.9849.9849.9849.9849.9849.9849.98
  000000000
   94.8494.8494.8494.8494.84   
   10.0910.0910.0910.0910.0910.0910.0910.09
   0.570.570.570.570.570.570.570.57
   2.862.862.862.862.862.862.862.86
   15.7115.7115.7115.7115.7115.7115.7115.71
   3.423.423.423.423.423.423.423.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

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
Super User
Super User

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@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. 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors