Forum Discussion
Solved
Powerbi reports
I have report1 which has some report count and everyday Data gets refreshed and the count also gets refreshed.datasourcebis some excel Data, I have another report2 which has sharepoint list and it h...
Hi bzeeblitz Could you follow these please
Load Data:
- Import Report1 (Excel with counts) and Report2 (SharePoint list).
Transform Data:
- Ensure Date columns match format.
Merge Queries:
- Use Power Query to merge datasets on Date (Left Outer Join).
Add Measures:
- Total PO Number:
COUNTROWS('Report2')- New Count:
SUM('Report1'[CountColumn])- Completed:
COUNTROWS(FILTER('Report2', [Status] = "Completed"))- No Action:
COUNTROWS(FILTER('Report2', [Status] = "NoAction"))Build Report:
Create a table visual with Date, Total PONumber, New Count, Completed, and No Action.
Refresh:
- Schedule data refresh for Excel and SharePoint in Power BI Service.
Hi bzeeblitz Could you follow these please
Load Data:
- Import Report1 (Excel with counts) and Report2 (SharePoint list).
Transform Data:
- Ensure Date columns match format.
Merge Queries:
- Use Power Query to merge datasets on Date (Left Outer Join).
Add Measures:
- Total PO Number:
COUNTROWS('Report2')
- New Count:
SUM('Report1'[CountColumn])
- Completed:
COUNTROWS(FILTER('Report2', [Status] = "Completed"))
- No Action:
COUNTROWS(FILTER('Report2', [Status] = "NoAction"))
Build Report:
Create a table visual with Date, Total PONumber, New Count, Completed, and No Action.
Refresh:
- Schedule data refresh for Excel and SharePoint in Power BI Service.
Actually existing power bi we have created this formula in the visualization report so that's the count we need to take from that dashboard
Bridgetable=Filter(Distinct('po[item:#]),Not(Isblank('po'[Item:#])))