Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello, I am trying to get a distinct count of products that fell into a category during a certain time period.
Product is connected to Date Table on DateTable.DtKey--->---Product.Initiation Date. Archived is connected to Date Table on Archived.DocVersionDate ---<>---DateTable.DtKey.
I want to know the distinct count of products that fell into a category during a certain time period. For example, between 2/21/2019 and 09/8/2019, there were 540 products that had an initiation date during that time. I want that number (540) displayed in the Doc Version Date of 02/21/19 because that's how many products were initiated before the new Doc Version on 09/09/2019.
Is there a simple way to do this using a measure, or would I have to alter something in my model or in Power Query to get this to work?
Solved! Go to Solution.
Hi, please try this link. I added the PBIX file and the Excel file where the tables come from.
https://drive.google.com/drive/folders/1ueuzxnHDi8fnba03ijc74P0oHSIo6KYC?usp=sharing
Below is the result I am wanting in the second table visual.
Thank you for your help!
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
107 | |
105 | |
89 | |
61 |
User | Count |
---|---|
169 | |
138 | |
135 | |
102 | |
86 |