Forum Discussion
Calculate Sales first year, second year etc.
Hello everyone, Can someone help me with the dax-formulas to calculate the sales in the first, second year and so on? The table: Invoicedate Invoicenumber Customernumber Amou...
Anonymous,
You may use DAX below to add a calculated column.
Column = Table1[Year] - MINX ( FILTER ( Table1, Table1[Customernumber] = EARLIER ( Table1[Customernumber] ) ), Table1[Year] ) + 1HI Anonymous
Sam's v-chuncz-msft formula gave the correct results when i tried it
Please see attached file
To get the average you can use
Measure = AVERAGE ( Table1[ Amount excl VAT ] )
Zubair_Muhammad
Community Champion
Community ChampionHI Anonymous
Sam's v-chuncz-msft formula gave the correct results when i tried it
Please see attached file
To get the average you can use
Measure = AVERAGE ( Table1[ Amount excl VAT ] )
Hi Zubair,,
You're absolutely right, the formule of v-chuncz-msft works, I did something wrong with my rows and filters.
I'm sorry for that. Your average-measure also works fine, thank you and v-chuncz-msft very much!
Greeting from The Netherlands,
Cor