Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |