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 Everyone,
I am working on my very first power bi report and I am stucked, wonder if anyone could please help me!
I am building a report to show compliance rate trend.
I have 2 sets of data table:
Table 1: Previous weeks' data,(this is a plain data table) showing compliance rate by manager by week.
Table 2.: New week's data, showing compliance status for each employee under 10 managers , assume total employee number is 100. The data is all text. I have created a measure to calculate the compliance rate using counta, and I am able to get compliance rate by manager for the new week.
Now I want to combine my new week's compliance rate to previous weeks' data as a new column so the report would look like:
Manager Name, Week 14, Week 13, Week 12, .......
Manager A, 86%, 90%, 85%...
Manager B, 88%, 87%, 90%...
Manager C, 99%, 89%, 85%...
I was trying to use lookupvalue function, but my problem is the data in Table 2 is not calculated, it just shows "compliant" or "not compliant" instead of compliance rate.
My approach might be wrong... any help is appreciated!
Thank you very much in advance.
S
Solved! Go to Solution.
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/create-new-SUMIF-colum/m-p/302501#M133709
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/create-new-SUMIF-colum/m-p/302501#M133709
it worked!!! terrific! thanks so much!
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 |
---|---|
102 | |
101 | |
78 | |
69 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |