Forum Discussion
Helper IVView the details
List1
Itemnumber Date
100. 3/17/2025
List2
ITEMNUMBER Date status
100. 3/15/2025. Not started
110. 3/14/2025. Inprogress
So I need to develop below report with below details
Output expected
Date. Totalnumber(list1)Notstarted(list2)
3/17/2025 1. 1
So when I click totalnumber I should see the respective item number for the specified date from the list1
Kindly help
16 Replies
- Khushidesai0109
Skilled Sharer
Hii bzeeblitz
Make a Date Table first of all. Join the Date table with the date columns of both tables. You have to mark the date table as "Mark as date Table". For that Click on the table and select the option.
Then make these measures
Total_Items = COUNT( List1[Itemnumber] )
Not_Started_Count =
CALCULATE(
COUNT(List2[ITEMNUMBER]),
List2[status] = "Not started"
)
Plot the Date from Date table created and measures that are created in table to get the required OutputIf this helps, I would appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!
bzeeblitzHow to make date table from both the lists. Kindly suggest
- Khushidesai0109
Click on New table -> CalenderAuto()
this will Create a new Date table
- Khushidesai0109
I am sharing you the PBIX file for you to refer which will help you understand the process
View the details.pbix
Here you can download it and can refer it.
If this helps, I would appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!- bzeeblitz
I'm getting unsupportive file type so please help me screenshot of it.manythanks
- Khushidesai0109
Sure, but you can download the file
- Khushidesai0109
Hiii bzeeblitz
Have you got it?Do you need any more help?
If this helps, I would appreciate your KUDOS!
Did I answer your question? Mark my post as a solution! Hi bzeeblitz
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi bzeeblitz
I wanted to check if you had the opportunity to review the information provided by Khushidesai0109 . Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi bzeeblitz
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
