I have some retirement data. Some employees are eligible to retire and are coded as such, NOW, OPTNL, or RD MI. I have a column that identifies if the employee can retire under any of these three conditions at three time points: Now, 1 Year from now, and 3 Years from now. I wanted to compare these figures for each program area we have. Our program areas are akin to a department in a company. It is supposed to replace a graphic initially created in Excel.
I put the COUNT for NOW and 3 YEARS in the VALUES section and the program area (DAS) in the AXIS section. But my graph shows the same numbers for both. I feel like I’m missing something.
This is awesome! I didn’t think I needed to create anything with it being so simple. I’ve watched the UBG to Power BI and the UBG to DAX, but I have no instincts around this as of yet. Thank you for your patience and assistance!
I bet everyone who’s read your post is nodding knowingly, since we’ve all been there. You watch the videos and think “seems pretty straightforward”, but when you sit down to do it yourself, you realize it doesn’t seem straightforward at all. The only remedy to this is practice, practice and more practice. That intuition will come steadily over time. And when you get stuck, just give a shout on the forum - tons of super talented folks here eager to help.
In addition to what Brian said just want to mention that DAX requires a shift in the mindset. You have to sit back and think a lot first before writing anything, it is basically like solving a Rubik’s cube.
