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
Super User
Super UserAnonymous , Have you tried like
crossjoin(distinct(Table[Date Full]), Distinct( Table[Plate Number])
or
crossjoin(CALENDAR(DATE(2021,1,1),TODAY()), Distinct( Table[Plate Number])
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)