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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors