Forum Discussion
Card in PowerbI not pulling the correct Data from Excel from SharePoint
Good Day, I have 4 excel documents that are saved in SharePoint. In each excel document it has a tab called Availability that allows the user to enter if they took a business, sick or vacation day d...
Hi KPro17 ,
On first scan, it sounds like you may have an issue with your model relationships. This behaviour is indicative of a crossjoin happening somewhere, but can't be sure without more information.
Can you provide copyable example data from all four of your SharePoint documents, as well as detail around what calculations you are trying perform across them please?
Pete
Query created when data pulled from SharePointplaceholder for vacation countPlaceholder for sick countPlaceholder for business countformula to calculate balance business leaveformula to calculate balance Sick Leaveformula to calculate balance vacation Leave
