User Profile
Parno
Frequent Visitor
Joined 4 years ago
User Widgets
Contributions
- 1.3KViews0likes0Comments
Gender Pay Gap Visuals
Hi to all the lovely people in my screen! I am looking for some help with a measure (I think!) please. I am currently trying to present some visuals on the Gender Pay Gap, I have a really basic data set to work with example headers below. From this I want to create a visual that shows the Median percentage difference between the male female hourly rate and visualise it into the 4 quartiles. I will also want to recreate this to show the mode. I also need to show the Median percentage difference between the male and femal bonus pay, I will also want to recreate this to show the mode. Example of result below (this would be the overall, then I want to show per quartile)1.3KViews0likes2CommentsRe: Calculate Column - Try to create an IF and AND statement
Thanks for your help! really appreciated - I get the following message - any ideas? DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.4.4KViews0likes2CommentsCalculate Column - Try to create an IF and AND statement
Hi although I'm not new new to PowerBI I am struggling trying to create a calculated column. I have named the column Leaver in the same year. I am running a data set on new starters - but also interested if they left within the same period, my attempt is below, Leaver in the same year = IF ((HESA Extract'[JOINER IN PERIOD] ="1"), AND (HESA Extract'[LEAVER IN PERIOD] ="1"),AND (HESA Extract'[TYPE] ="Continuing"),'Yes, No")) Can anyone tell me where I am going wrong?Solved4.5KViews0likes8Comments
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.