last sales date and sales amount

last sales date and sales amountFollow
An ast
An astSep 28, 2022 12:26 PM
Hi, I’m new to PBI and try to figure out how to get the last date when a product was sold and the sales …
1. last sales date and sales amount

An ast
Posted Sep 28, 2022 12:26 PM
Hi, I’m new to PBI and try to figure out how to get the last date when a product was sold and the sales amount associated with that date.
There are 3 tables:
Product Dim: ProductID ,ProductName ,Sales Channel Type (reseller or internet), Others …. . One product ca
Reseller Sales Fact: ResellerSalesID, ProductID ,Sales Date ,Sales Amount, Sales Qty
Internet Sales Fact: InternetSaleID ,ProductID ,Sales Date ,Sales Amount ,Sales Qty

I need to get a list with last date and sales amount with data from both table (reseller and internet).
Product Name, Last Sales Date, Sales Amount

So far, been trying MAXX, Filter and Top 1 whiteout success.

Thank you in advance
An

——————————
An ast
——————————

2. RE: last sales date and sales amount

Gold Contributor
David Gerard
Posted Sep 29, 2022 04:16 AM
Bonjour An

Est-ce que votre jeu de données comprend une table de dates reliées à ces autres tables ?
Pourriez vous mettre à disposition un échantillon de vos données dans un fichier PBIX pour nous aider à mieux comprendre la situation et pouvoir mieux vous aider ?
Ca aide beaucoup de voir un exemple concret.

——————————
David Gerard
Power Platform Consultant
——————————