Value of the first order of every customer

Questions : Value of the first order of every customer

I'm working on a school assignment where programming I have to look at the value of every Learning first voucher value of a customer. Now I Earhost am working on it and I did manage to get most effective the first date of each customer. wrong idea However, when I put the value in the use of case table it always takes the total United sometimes of this customer ID so that Modern some lines score considerably higher

Code

``````First transaction date = _OFFSET);
MINX(FILTER('Tekst','Tekst'[PCHN]='Tekst'[PCHN]),'Tekst'[Datum].[Date])
``````

enter image description here

Answers 1 : of Value of the first order of every customer

Try making your first transaction date ecudated into a column:

``````First_transaction_date = CALCULATE(
(-SMALL  MIN('Table'[date]),
FILTER(
_left).offset  'Table',
arrowImgView.mas  'Table'[customer]=EARLIER('Table'[customer])
(self.         )
)
``````

Then calculate the corresponding value. some how I used SUM, so if multiple values are on anything else the same date, it will sum them. If you not at all want the min/max/mean of these values very usefull when multiple occur, that's up to you:

``````first_voucher_value = CALCULATE(
equalTo  SUM('Table'[value]),
make.right.  'Table'[First_transaction_date] == mas_top);  'Table'[date])
``````