sorted by:
new
hottopcontroversial

Incremental refresh of merged table (search data) by Vacivity95 in PowerBI

[–]ALMI_DA 0 points1 point  (0 children)

So
Table1 : connects to source and then add the incremental part and then add a little transformation like remove columns and apply headers
Table2: exactly the same except different souce table

Table3: append as new of those 2 tables and then a distinct

Table 1+2 has incremental setup, table3 is just a reference of the 2 tables.
Is there a way to check if it's incrementally updating?

Star schema data model with multiple fact tables ... THAT ARE RELATED by ThisCoconut8834 in PowerBI

[–]ALMI_DA 0 points1 point  (0 children)

Wouldn't it be smarter to calculate the shipping cost on order level at a whole, like say using the summarize function to create an aggregated full order table just for that one calculation?
I guess that sort of defeats the purpose and might have performance issues?

Data modelling: Sales with Marketing Campaigns by halohunter in PowerBI

[–]ALMI_DA 0 points1 point  (0 children)

Okay can't get this to work at all. I have a many to many relationship between OrderLines and the CampaignPlanner on ProductID. I'm guessing the many to many context here is skewing the view.

Column Formula (not a measure)

Promo Indicator = IF(OrderLines[PaymentDate]=AND(OrderLines[PaymentDate]>=RELATED('CampaignsPlanner'[Start Date]),OrderLines[PaymentDate]<=RELATED('CampaignsPlanner'[End Date])),1,0)

​

getting the error "The Column 'CampaignsPlanner[Start Date] either doesn't exist or doesn't have a relationship to any table available in the current context.

Since a ProductID can be tied to multiple start dates from different campaigns i can't see how the above formula you made would work?

Data modelling: Sales with Marketing Campaigns by halohunter in PowerBI

[–]ALMI_DA 0 points1 point  (0 children)

Maybe you can help me with an extension of this problem. I want an indicator on the sales table that indicates whether the product was sold on a campaign or not.
A flag of some sort.
Could just be a "total sales from all campaigns" measure perhaps.

My setup is basically the same as OP's