Forum Discussion
Creating a distinct table for each month using a Dates Table and another table
Hello there, I have a table that has daily inputs for job orders that looks like this: Date Full Plate Number Month 1/1/2021 Job Order 1 Jan 1/1/2021 Job Order 2 Jan 1/1/202...
amitchandak what ended up working thanks to your inspiration was
CALCULATETABLE(CROSSJOIN(DISTINCT([Date(Month)]),DISTINCT([Job Order])),Filter)
amitchandak that is giving me all the months I only want the months that exist
amitchandak what ended up working thanks to your inspiration was
CALCULATETABLE(CROSSJOIN(DISTINCT([Date(Month)]),DISTINCT([Job Order])),Filter)