Forum Discussion
Need help
Thank you for your reply.
I am going to do my best to explain the data and situation with sampple.
This is what i have , Two tables.
Table 1 is my BASE table and table 2 can be considered my result table.
One problem is table 1 doesnot have any date coloumn.
The relation between table 1 and table 2 is created.
I want to create a visual where all equipment numbers exist all 1324 weather they have a work date or not.
I created a sample visual below that I want. I have tried creating a new summarize table from table 2 but every time I use a month filter it filters out the equipment numbers from table 1 that have no work date.
Hope you can help.
I will attache the file that I am using.
Raj2410 OK, so the big problem here is how are you differentiating those different groups that you have highlighted? There needs to be something that tells DAX or the visual that those rows are separate things. I don't see anything in your visual or the data that could tell DAX or the visual that the first 4 rows belong together, then the middle 6 rows belong together and then the last 9 rows belong together.
Thanks Greg , do you have any suggestions based on the data I sent