Hello Everyone,
i have a table with 3 column.
work order; item, and date
I need to calculate days between dates for every workorder/item.
Was able to determine item rank under each work order (with dax), but can't figure out how can i calculate days. :(
Attached the base table, so if anyone...
Hi,
When you change the M/c no: in the data sheet, you need to change the filter option in the allocated sheet.
update: https://www.dropbox.com/s/4lnwf3kic3wi1w7/sreejeshc_test1_file.xlsx
Hi sreejeshc!
Take a look to the attached file.
In this version there is no "allocate" button. When you update the master sheet, excel will recalculate all formula.
https://www.dropbox.com/s/4lnwf3kic3wi1w7/sreejeshc_test1_file.xlsx
Regards,
bigzolie
(sorry for my bad english)