Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a table A
Person ID | Hours | WK ID |
AME374 | 0.5 | 22335 |
AME374 | 0.5 | 11223 |
BBO243 | 6 | 66223 |
BBO243 | 1.5 | 11223 |
BBO243 | 0.5 | 66223 |
BCO57 | 0.5 | 22335 |
BCO57 | 0.5 | 11223 |
CPF060 | 0.5 | 11223 |
CPF060 | 0.5 | 66223 |
CPF060 | 0.5 | 22335 |
another table B
WK ID | Status date |
22335 | 04-2022 |
11223 | 04-2022 |
66223 | 01-2023 |
They are connected by a WK ID
I want to create a DAX measure to sum hours based on person ID from table A and Status date from table B
so measure would give for AME374 for 04-22 , hours= 1 since both WK ID fall in 04-2022
Person ID is in different table A and status in table B and they are connected by WK ID, s a DAX measure has be created to sum hours for each person for each month
1,put the Person ID in the row, and Status Date in the column
2,create a mearsure, and put it in the value area
TotalHours=SUM(TableA[Hours])
the you can get this
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
13 | |
11 | |
10 | |
9 |
User | Count |
---|---|
18 | |
14 | |
14 | |
12 | |
11 |