Count the number of working days consumed or remaining month to date
I am trying to work out a Beast Mode Calculation on a dataset that I have that will tell me how many working days have elapsed since the 1st of the current month, or how many are left.
I have a value in my dataset which tells me how many working days there are in the current month, I'm struggling with trying to figure out how many have been used up.
I looked at trying to join the DOMO Calendar to the dataset but I can't figure out how I could do that as my data set is produced daily and has a whole bunch of summary numbers and the only date is the last updated date so I'm stuggling with what to join on.
Any help will as allways be appreciated
By the way I"ll be in Salt Lake for Domopalooza tomorrow afternoon so if anyone can help and wants to meet up that would be great.
Drinks on Me !