User Profile
alevandenes
Helper IV
Joined 6 years ago
User Widgets
Contributions
Re: Number of people working per day
Hi, Let me clarify it: - "Shift" shows if, according to the shift, the person is working that monday or not. it states zero because the shift says "monday off" - it is a measure at the moment and this is the DAX: MondayCalc = SUM('WorkSchedule in Details'[monday])* DISTINCTCOUNT(TMsAndAgencyTemps[DisplayName])638Views0likes0CommentsNumber of people working per day
can you please help me calculate the number of people working on a specific day of the week? in particular, i am struggling with the calculation of the total. it gives me 3*14= 42 instead of 13 (=the sum of all mondaycalc) thanks a lot in advance!!!Solved696Views0likes4Comments- 705Views0likes0Comments
Split dataset into columns and rows
Hi, i would like some help. i need to analyze in powerBI some machine data, that unfortunately are provided to me this way. I would need to have the rows from SO# to finished time into columns and the rest as different rows. Do you know of a way to do this? This is the structure i would like to have: Thanks a lot for your help, AlessandraSolved783Views0likes2CommentsRe: calculated column based on column content
I might need your help a bit more. this is working, but i also need the condition that the AR number needs to be the same. in my screenshot you see that there is a column with a Audit response number. could you help me integrate it in the formula? Again, thanks A LOT for your help.744Views0likes2Commentscalculated column based on column content
Hi, could you help me come up with a calculated column that shows "Failed VOE", when the next phase after Verification of Effectiveness/Verification of Effectiveness approval is Initial response? the Phase_tick_id are giving the correct order of the phases. Thanks a lot!! forever grateful to whom can help me Kind regards, AlessandraSolved798Views0likes4Comments- 952Views0likes0Comments
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.