Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
pbiforum123
Post Patron
Post Patron

stock gainers and losers

 

Can someone help me achieve this in Power BI. 

 

1. Top 3 gainers vs losers across daily, weekly and monthly price moves

2. Show the value and the % by which an asset moved to make it into the above top/bottom buckets

Power BI file should contain below 

. A PowerBI file with a Summary page that shows the top/bottom 3 asset price changes with filters to switch between daily, weekly and monthly price changes 2. A short presentation on the summary of the task with key observations on the data

 

I need to dax to achieve the above requirement please help

 

https://1drv.ms/x/s!Alon3Yp1YN1UjgU7QqRRrErb0ghD?e=G5mEE9

 

 

3 REPLIES 3
pbiforum123
Post Patron
Post Patron

Can someone help me on this?

pbiforum123
Post Patron
Post Patron

 

@amitchandak @Greg_Deckler @Ashish_Mathur @mahoneypat 

Just share some details on how I can achieve this. I am little confused how can i show top 3 gainer and top 3 loser daily,weekly and monthly.

Can someone please help on this? It is little urgent? Challenge if to how find the weekly and monthly price moves. 

 

Please help!

 

@Greg_Deckler Can you please help me here?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.