Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all!
I would like to get help on creating a new measure that count distinct rows after a specific date.
In a column I have the so called "CI Status" - For the CI status related to the following
"W/ Released Solution"
"W/ Sustainable Containment"
"W/ Impl. Permanent Sol."
I would like to count if there are any new technical issues (TI) linked after its Date: CI Closed
Any suggestions of how a DAX measure could look like for thid scenario?
Best regards,
J
Your requirement is not clear. Please show sample data and expected result.
Regards,
Jimmy Tao
Hi,
Currently am working with Cost Poor Quality data and further would like to highlight all Technical issues (TI) and related cost that has been linked to a Consolidated Issue (CI) after its Date: CI Closed.
Example: If a CI was closed on date 2019-01-01 with a solution then I would like to monitor if new Technical Issues was logged after that date and its related cost.
Date: CI Closed
2019-01-01
2018-06-30
2017-04-05
....
The Column Date: CI Closed has different dates depending when a solution was in place. I would to monitor all new Technicla issues and related Cost logged after thoses dates. a technical issue has a occurrence date.
so the Occurence date should always be after the Date: CI Closed.
is it possible to display values only after Date: CI Closed?
Best regards,
Jala
I think you will have to post some sample data for us to understand what you're trying to do, instead of just column names or values.
Help when you know. Ask when you don't!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |