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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |