DAX

Question

Hi,&nbsp;I am having an idea but don't know how to execute in DAX. I want to calculate a new column where the product(s) that a specific cliënt has used before the latest product-use is returned. For example:Product &nbsp; &nbsp; &nbsp; Cliënt &nbsp; &nbsp; &nbsp;&nbsp; Earlier product &nbsp; DateA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mrs. Smit &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2018B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mrs. Smit &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2017A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mr. Apple &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2018Can anyone help me?&nbsp;

anonymous · Answer

Why don't you do it in Power Query where such calculations belong? Please note that calculated columns should only be used if THERE IS NO OTHER OPTION. This is because calculated columns have a poor compression rate.

Best
Darek

anonymous · Answer

Thanks for the feedback Darek. I am not very familiar with Power Query, but if I was, how would I need to go about it, huh?

Or if u know an R script or a DAX measure that allows me to do this without calculating a new column than I am all ears too.

anonymous · Answer

Mate, the table you've given is not only too small to see what you need but I think the second row is incorrect. Why the heck do you have A in there as the earlier product? Please give us some proper data and explain correctly what you want.

Thanks.

Best
Darek

Forum Discussion

DAX

3 Replies

Related content

Dax

DAX

DAX Behavior

DAX Formula Help

DAX