Forum Discussion
Use one date table
Hi everyone, I`ve using power bi since one year, and i cant solved this. I need to have one table of dates in order tu use that table to filter many other tables. The thing is that i cant make ...
Anonymous what is the issue? if you have inactive relationship between employee and date table, you can make it active using USERELATIONSHIP function.
For example, the following measure will count the employees and if you use this measure, you will able to get the count based on date slicer.
Count Employees =
CALCULATE ( COUNT ( EmployeeTable ), USERELATIONSHIP ( EmployeeTable[Date], DateTable[Date] ) )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡