Forum Discussion
Converting a payroll data Measure into a Table Column
sjhand , if you have start and end date of week, then refer if these can help
Between Dates - Dates between
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785
Tables way
https://amitchandak.mediumcom/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
amitchandakthis is great. I am looking at the tables method and hoping to use the GENERATE function.
I have start and end dates in the data and should be able to use GENERATE to replicate each row 14 times as each payroll covers 14 days.
Now how can I distribute some of the payroll cost fields into each of the replicated rows? Can I simply nest my current measure into the GENERATE function?
For example, I used GENERATE for one of the payrolls that covers 7 days in the example below and it created 7 rows, which makes sense. How can I split [Bi-Weekly Earnings], [Total Hours], etc. 7 ways into each one of the dates?
