Forum Discussion
Solved
Total count for specified date
Itemnumber. Date. Status 1. 3/15/2025. Notstarted 2. 3/14/2025. Notstarted 3. 3/14/2025. Completed Expec...
Hi bzeeblitz,
Please create the following measures:
Count Item Number = COUNT('Table'[ItemNumber])Count Not Started = IF(ISBLANK(CALCULATE([Count Item Number], 'Table'[Status] = "Notstarted")), 0, CALCULATE([Count Item Number], 'Table'[Status] = "Notstarted"))Count Completed = IF(ISBLANK(CALCULATE([Count Item Number], 'Table'[Status] = "Completed")), 0, CALCULATE([Count Item Number], 'Table'[Status] = "Completed"))Then insert them in a table:You can order your table by Date Desc
If my answer fullfil your question, plase flag it as solution
why we don't display itemnumber 3 ?
Hey ryan_mayu, I think he wants them grouped by Date and count them.
At least this is how I interpreted it.
Yes I want to group by date from two different lists and then show report
List1
Date. Itemnumber
List2
Date itemnumber. Status
So when I group by date then I need to show below columns
Final result
Date itemnumber status
Then please feel free to review my prevuous comment
We can display I just showed sample data that's it, however we got to show the entire data
