Forum Discussion

vipinverma11's avatar
vipinverma11
Frequent Visitor
2 years ago

need help in dax

Hi,   I am looking to create a measure for the below table, I have date column with respect to workcenter number, total labour hour will tell you the booked hours on that date & WC_ hours is hours ...
Need Help
vipinverma11's avatar
vipinverma11
Frequent Visitor
2 years ago

Hi, 

 

Thanks for your efforts, i am not able to achevive the result, for spill over i have used the formula "

 

"

Spill_over = IF('Current& Future Steps SQL (2)'[total labour hours]>'Current& Future Steps SQL (2)'[WC_hours],'Current& Future Steps SQL (2)'[total labour hours]-'Current& Future Steps SQL (2)'[WC_hours],0)

"

 

I have exported the Data for only one workcentre which will show 200 right now. same we have other workcentre as well and i have used index formula 

Index = RANKX(FILTER(ALL('Current& Future Steps SQL (2)'), 'Current& Future Steps SQL (2)'[OP Workcenter] = EARLIER('Current& Future Steps SQL (2)'[OP Workcenter])), 'Current& Future Steps SQL (2)'[OP Start Date], , ASC) to start indexing from 1 to 365 for each work centre.

I am attaching the dataset in reply post
vipinverma11's avatar
vipinverma11
Frequent Visitor
2 years ago

Sample Data  I have uploaded in the drive