topic Re: Group by several criteria and take oldest available value in DAX Commands and Tips

Group by several criteria and take oldest available value

PawelTr — Wed, 10 May 2023 14:28:34 GMT

Hello!

I'm struggling with DAX code.

To describe the problem, look at the picture below. I have many rows with the data, separated by invoice month, country, section, supplier type. In next four rows are some values, let's focus as example on Sum_selling_price

I want to create calculated column, which always take value for first available month(here it will be April) and assign in all 12 rows.

My current code, where I failed looks as provided

I faced "circular dependency".

I would be really grateful for any help.

Re: Group by several criteria and take oldest available value

v-zhangti — Fri, 12 May 2023 06:55:25 GMT

Hi, PawelTr

You can try the following methods.

Selling price = Var _firstdate=CALCULATE(MIN('Table'[INVOICE_MONTH_END]),ALL('Table')) Return CALCULATE(SUM('Table'[Sum_selling_price]),FILTER('Table',[INVOICE_MONTH_END]=_firstdate))

Is this the result you expect? If not, please provide more information.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Group by several criteria and take oldest available value

PawelTr — Wed, 24 May 2023 10:03:26 GMT

Hello v-zhangti,

Sorry for beeing silent for a long time. I wasn't able to log in recently.
Your advice helped me solved this problem.

A veeery big thank you for this support! 😊