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.
I've got 4 tables:
1) COMPANY (Company ID, Company Name, ...)
2) EMPLOYEE (Employee ID, Company ID, Employee Name, ...)
3) LOGINS (Login ID, Employee ID, Login Date, ...)
4) DATES TABLE
I want to show the total count of Logins for COMPANY for Current month and previous month to get below:
-----------------------------------------------------------------------
| COMPANY NAME | CURRENT MONTH | PREVIOUS MONTH |
| Company A | xxx | yyy |
| Company B | aaa | bbb |
| ... | ... | ... |
----------------------------------------------------------------------
I am not sure what measures to create. Nothing seems to be working.
Thanks in advance.
Solved! Go to Solution.
You need to have the relationship in star schema and apply below measure:
This appears to work IF I have a DATE FILTER for the previous 11 months only.
Otherwise, it appears to be totalling months from previous years. ex: CURRENT MONTH = Aug 2019+Aug2018+...
Seems you need to add filter for year also.
Brilliant. Thank you.
Proud to be a PBI Community Champion
You need to have the relationship in star schema and apply below measure:
I have the schema like below. I will build now and see how it goes.
Proud to be a PBI Community Champion
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |