topic Need suggestion on Dax in DAX Commands and Tips

Need suggestion on Dax

Madhuri_varma — Wed, 02 Jul 2025 07:38:13 GMT

I have current scores and need to get previous scores for the data which is taken weekly basis. When there is change in value it is showing duplicate record. One for previous and other row for actual score

Re: Need suggestion on Dax

bhanu_gautam — Wed, 02 Jul 2025 10:01:02 GMT

Madhuri_varma , Can you explain exact outcome as current requriement is not clear

Re: Need suggestion on Dax

v-karpurapud — Wed, 02 Jul 2025 10:43:01 GMT

Hi Madhuri_varma

Thank you for sharing your DAX requirement. From your description, it seems that you're working with weekly data and aiming to retrieve previous scores alongside current ones. However, you’re encountering duplicate records when the score changes one row reflecting the previous score and another showing the actual score. To provide an accurate and effective solution, we would need a bit more clarity on your expected outcome. Specifically, it would be helpful if you could share a sample of your dataset (including key columns such as date, score, and any relevant identifiers), clarify how current and previous scores should be calculated, and provide an example of the desired output format. This additional context will enable us to better understand your scenario and guide you appropriately.

Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.

Re: Need suggestion on Dax

maruthisp — Thu, 03 Jul 2025 00:44:12 GMT

Hi Madhuri_varma ,

Based on the original description, as per my understanding:
Show each week’s score alongside the with prior week’s score, without duplicating entire rows when values change.

Please find the attached pbix file with sample data and dax measures to help to acieve the solution.
current score and the prior weeks score.pbix

Please let me know if you have further questions.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!

Best Regards,

Maruthi

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/

X - Maruthi Siva Prasad - (@MaruthiSP) / X

Re: Need suggestion on Dax

v-karpurapud — Mon, 07 Jul 2025 04:51:22 GMT

Hi Madhuri_varma

We haven't heard from you in a while. We're ready to help resolve your issue, but we need more details from you. Please provide the necessary information so we can better assist you. If your issue has already been resolved with the previous solution by maruthisp , please mark it as the accepted solution.

Thank You.

Re: Need suggestion on Dax

v-karpurapud — Thu, 10 Jul 2025 10:06:51 GMT

Hi Madhuri_varma

I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.

Re: Need suggestion on Dax

v-karpurapud — Mon, 14 Jul 2025 05:03:33 GMT

Hi Madhuri_varma

We have not yet received a response from you regarding your query if you find the response helpful, kindly mark it as the accepted solution and provide kudos, as this will aid other members with similar queries.

Thank You.