Generate Custom Table of DATES and CROSSJOIN
Hello everyone, I need a PBI expert's help. Please refer to the table I've copied over. I need to generate a table of custom dates and information. Essentially using this table, I need DAX to generate a table/list of all Mondays [DDD] from the 1st week of the month [Month_Week_Num] for the given timeframe [Block Effective Start Date] - [Block Effective End Date] for each of the [Surgeons] which I've blinded. I think it's a matter of using a combination of FILTER CROSSJOIN UNION, etc but I can't seem to get it to work. For instance, just looking at Surgeon 1, the table should look like: 1/3 Mon Surgeon A 2/7 Mon Surgeon A 3/7 Mon Surgeon A 4/4 Mon Surgeon A 5/2 Mon Surgeon A 6/6 Mon Surgeon A 1/3 Mon Surgeon B 2/7 Mon Surgeon B 3/7 Mon Surgeon B 4/4 Mon Surgeon B 5/2 Mon Surgeon B 6/6 Mon Surgeon B Any help would be appreciated.
