Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello, I have a visual table that shows the count of distinct dates from customer ordes, but I was asked to put in the the table second date (in case there were changes).
The first picture shows the original table I had:
Then I used this formula in a measure to get the second date and it worked correctly, but I had 1 order filtered when I created the formula:
After I removed all the filters, I realized that the table is now showing the second date of all the orders, but I want to see the second date of a the order and Item #. How can I change the formula to get the right date?
Thanks,
Brainer
Please provide sample data in usable format (not as a picture) and show the expected outcome.
Check out the November 2025 Fabric update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!