topic Re: Need to summerize please- all sandwitch salads belong to same day . how to combine all in to one row in DAX Commands and Tips

Need to summerize please- all sandwitch salads belong to same day . how to combine all in to one row

AIwithBI — Wed, 16 Feb 2022 17:58:01 GMT

Please, help
looking for all in one row dax function ( calcullated table)
all Sandwitches Salad belong to same day how to combine to one row? Please, Thanks

Re: Need to summerize please- all sandwitch salads belong to same day . how to combine all in to one row

tamerj1 — Wed, 16 Feb 2022 18:55:44 GMT

Hi AIwithBI

Use CONCATENATEX. If you can provide more details I may help you out.

Re: Need to summerize please- all sandwitch salads belong to same day . how to combine all in to one row

AIwithBI — Wed, 16 Feb 2022 21:56:48 GMT

tamerj1 Thank you, concatenatex wont stop from specific date. It's keep adding entire column.

Would you please help me to stop from specific date?

Thanks

Re: Need to summerize please- all sandwitch salads belong to same day . how to combine all in to one row

AIwithBI — Thu, 17 Feb 2022 01:29:21 GMT

Looking for solutions to combine multiple rows within the same day into a single row into something like below, is this doable using power query or DAX

Re: Need to summerize please- all sandwitch salads belong to same day . how to combine all in to one row

v-kkf-msft — Mon, 21 Feb 2022 10:06:43 GMT

Hi AIwithBI ,

Please click Transform -> Group By. The Group By dialog box will open. Then calculate the maximum value for [Sqnwitch salads] column.

Then edit the M code in the formula bar.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.