topic Re: DAX query to compare previous values in DAX Commands and Tips

DAX query to compare previous values

rsrajkumar — Sat, 21 Dec 2024 19:21:06 GMT

I am new to PowerBI. I need help in creating a DAX function for the below table named 'Cases'. The requirement is to Sum the Column 'Value' that have the same 'ID'. For example the DAX expresssion should return 1 for A1B, 2 for B2C, and 1 for C2A

Re: DAX query to compare previous values

lbendlin — Sat, 21 Dec 2024 23:23:41 GMT

Have you tried putting both columns into a table visual - you should get your desired result without DAX.

Re: DAX query to compare previous values

rsrajkumar — Sat, 21 Dec 2024 23:50:08 GMT

Thanks @Ibendlin. While for this specific example the table works as mentioned by you (did not know that until now), my actual use case is complex that I would need the DAX expression. Request if you can please help me

Re: DAX query to compare previous values

lbendlin — Sat, 21 Dec 2024 23:55:49 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: DAX query to compare previous values

rsrajkumar — Sun, 22 Dec 2024 00:31:55 GMT

lbendlin I tried the table visual solution with additional filters, and it worked. Thanks a lot!