User Profile
KCDG60626
Regular Visitor
Joined 3 years ago
User Widgets
Contributions
Cross Sale Analysis
I am trying to create a Cross Sale analysis with an undetermined amount of product groupings. This needs to be a calc column within the fact table that has no attribute relationships. The code below works in Power BI and gives me the output that I am looking for however when I go to add it to my power pivot it returns the error: "Cannot query internal supporting structures for column 'Fact'[Cross sales] becuse they depend on a column,relationship or measure that is not processed. please refresh or recalculate the model" Here is the code (DAX): ProductGroups = VAR totalCustomers = VALUES ( 'Fact'[Customer ID] ) VAR AllProducts = VALUES ( 'Fact'[Line of Business] ) VAR productCombinations = CROSSJOIN ( totalCustomers, AllProducts ) VAR FilteredCombinations = FILTER ( productCombinations, 'Fact'[Customer ID] = EARLIER ( 'Fact'[Customer ID] ) && 'Fact'[Line of Business] <> EARLIER ( 'Fact'[Line of Business] ) ) VAR ProductGroup = CONCATENATEX ( FilteredCombinations, 'Fact'[Line of Business], ", " ) RETURN IF ( COUNTROWS ( FilteredCombinations ) > 0, ProductGroup, "No Cross-Sale" )354Views0likes1CommentExport power query into SQL server
I am having trouble finding a way to Export an Excel query into a SQL server. One of my options is to export from SAS to export into excel (Maybe using VBA?) and then using SSMS to export it into the server. Ive tried the export directly into SSMS but am running into the Ace.OLEDB not provided error. If there is a VBA code to connect to the two softwares thatd be awesome, if not what else can i do?356Views0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.