Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Share data of the 2 tables in a format that can be pasted in an MS Excel file and for those 2 tables, show the expected result.
The excel shows the two fields. Project ID and Baselinenumber. In the Projects Baseline table, the ProjectID can have Baselinenumber 0, 1, 2, 3, etc. Baselinenumber 0 is the primary baseline used for project schedules and we want to show in the table with the X's what projects DO NOT have a baseline 0. We don't care about the 1, 2, 3, etc. Here is my SQL query that is successful at returning the correct projects.
SELECT DISTINCT d.projectnumber, d.projectname
FROM [dbo].[Projects Data2] d
WHERE d.projectnumber is not null
and d.projectstatus = 'active'
and NOT EXISTS (
SELECT 1
FROM [dbo].[Projects Baseline2] b
WHERE b.ProjectID = d.ProjectID
AND b.BaselineNumber = '0');
Hi,
Write this measure
Measure = calculate(distinctcount(Data[ProjectID]),Data[baselinenumber]<>0)
Hope this helps.
@deeave , Try like
COUNTROWS (summarize(Filter( 'projects baseline2','projects baseline2'[baselinenumber] = 0 ), 'projects baseline2'[projectid]))
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 |
---|---|
109 | |
101 | |
84 | |
79 | |
69 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |