Need suggestion on Dax

[Madhuri_varma]

 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 

 

[v-karpurapud]

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.

[v-karpurapud]

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.

[v-karpurapud]

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.

[maruthisp · Accepted solution]

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

[v-karpurapud]

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.

[bhanu_gautam]

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