Forum Discussion
CJANE
Helper I
8 years agoCompare 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
- AnonymousNot applicable
Hi
Use DAX formula ( CALCULATE & FILTER) which will override the context.
Thanks
Raj - v-jiascu-msft
Microsoft Employee