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,
I'm trying to create a line chart with running totals for three measures I created.
The problem is my fact table has 3 date columns - I've created inactive relationships with my Date table but becuase the measures aren't straightforward I'm struggling.
The data has the following headers:
Unforuntaley participant status is only reliable for two measures and for the other I have to count total rows and using COUNTA as the status randomisation can change later on.
They are:
I can't get the USERELATIONSHIP to work, but I need to connect to the following columns:
Total Randomised is Randomisation Date
Total Withdrawn Post-Rand and Total Completed are Date of Completion / Withdrawal
Any ideas?
Best,
Soph
Solved! Go to Solution.
Hi Experts, I have been trying to group or split (can't find the exact word) the rows of the first column (PP_NO). I need to have 2 have two separate columns, one for 1 and the other for two. And also combine data of the same date in a column.
Please advise how do i do that.
Solved!
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |