Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I'm having a tough time determining the DISTINCTCOUNT of [SO_ID] by Quarter and Year.
When I show the data by indivdual Date it works fine, but when I use Qtr & Year the total is less because a SO_ID may be shipped from multiple times throughout the Quarter. I've tried REMOVEFILTERS on the Qtr & Year date column and had no luck.
Here is the current DAX formula.
I abandoned this project.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.