Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Hi @CJANE,
Can you share a sample?
Best Regards,
Dale
Hi
Use DAX formula ( CALCULATE & FILTER) which will override the context.
Thanks
Raj
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |