Forum Discussion
Dynamic selection of Common records between multiple tables
See attached for a proposal to show bars 1 to 4. I don't understand the logic for bars 5 and 6.
Super UserYou have not provided sufficient sample data. Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thank you for you response and Help.Please find the below drive link for the excel files.
usp=sharinghttps://drive.google.com/drive/folders/1ZxxDJa8ExfB1yqjSZv-3dZnLgkupwCCN?usp=sharing
My Expected out come is as below:
with a filter like latest 4 months
Those 6 bars shoud show:
Bar1 : Count of total material
Bar2 :Common material folder count between selected 2 months(by default 4months Common material folder count )
Bar3 :Common Success material folder count between selected 2 months(by default 4months Common success material folder count )
Bar4 :Common Failed material folder count between selected 2 months(by default 4months Common failed material folder count )
Bar5:Common material Folder Count Succeeded in Max-1 month( in this case Sep) and Failed in Max month (in this case Oct)(We have data from July to Oct)
Bar6:Common material Folder Count Failed in Max-1 month( in this case Sep) and Success in Max month (in this case Oct)(We have data from July to Oct).
your help would be greatly appreciated thank you in advance.
- lbendlin
See attached for a proposal to show bars 1 to 4. I don't understand the logic for bars 5 and 6.