User Profile
LeonardCs
Helper I
Joined 2 years ago
User Widgets
Contributions
HELP WITH DAX - DATE CALCULATION CONDITION
I have a calendar table and a table with all the employees of the company. In this employees table, there are details like employee ID, admission date, and dismissal date for those who have already been dismissed. Those who have not been dismissed yet have a blank dismissal date. I need to calculate three indexes: A - Total employees hired during the period (I have already calculated this) B - Total employees dismissed during the period (I have already calculated this) C - Total active employees during the period (I am unable to calculate this) For example, if I have a filter for the year 2025, I need to know how many employees were active in 2025. If I select the year 2024, I need to know how many employees were active in 2024. How can I do this in DAX? Please note the following conditions: The employee's admission date must be less than or equal to the date selected in the filter of the calendar table. The employee's dismissal date must be greater than or equal to the date selected in the calendar table filter, or the dismissal date can be blank. I am sending the .pbix file as an example of what I need. I would be very grateful if you could help. Thank you https://drive.google.com/drive/folders/1nAGe89KiFBD3DYaTaGJylqa9O-qpELD_?usp=drive_linkSolved588Views0likes2CommentsError conection
Hi everyone, I have a dashboard that connects to SQL Server. I downloaded a gateway, but when I refresh the dashboard online, I receive the following message: "Failed to update data source credentials: Could not locate the requested .NET Framework Data Provider. It may not be installed." Can someone help me with this?Solved622Views0likes2CommentsHELP WITH DAX
Hi guys, I have a table with colummn that contains several numbers and I need to sum them. It would be easy, but in this colummn I have some words together and I can't take this words. for exemple: Values: 10,00 20,00 not yet 30,00 loading 40,00.... How can I creat a measure that just sum the numbers disregarding the words?Solved1KViews0likes6CommentsNEED HELP WITH DAX
Hi everyone, I have a table with some types of exams and I need to calculate total of them. The issue is that some exams are in column "Exames_Realizados" and some exams are in column "Exames_Adicionais". For exemple: Name Exames_Realizados Exames_Adicionais Leonardo BIÓPSIA POR ESTEREOTAXIA RNM Rafael BIÓPSIA POR USG BIOPSIA DE LINFONODO Will BIÓPISIA TIPO1 BIÓPSIA POR USG Sophie MMG AGUARDANDO Taylor PAAF LINFONODO BIÓPSIA POR ESTEREOTAXIA Pitty PAAF TIREOIDE SEGUIMENTO PELA ESF Bryan RNM USG Maria USG BIOPSIA DE LINFONODO John DOPPLER USG I need to know and show how much exams for types were carried outSolved2.1KViews0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.