cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CJANE Regular Visitor
Regular Visitor

Compare price for two dates

I am trying to builld a report using a table visualization comparing the price of a security for two different dates.  I only have three data points - security id, price and date.  In my visual I want to add price twice to my values creating two columns but each price column controlled by a separate date filter so the user can pick which dates to compare.  Any suggestions?

 

 

 

2 REPLIES 2
rajendran Super Contributor
Super Contributor

Re: Compare price for two dates

Hi

 

Use DAX formula ( CALCULATE & FILTER) which will override the context.

 

Thanks
Raj

v-jiascu-msft Super Contributor
Super Contributor

Re: Compare price for two dates

Hi @CJANE,

 

Can you share a sample?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 264 members 3,030 guests
Please welcome our newest community members: