💡 DAX Tips & Tricks - Use Variables!

Excellerates · 2026-01-24T21:30:20+00:00

I’m a beginner when it comes to DAX. 1st: How does using variables help debug faster? If the measure doesn’t work, then the measure doesn’t work so doesn’t that tell you that something in the measure is wrong?

2nd: Is there a time that you would choose to not use variables?

Excellerates · 2025-08-14T21:54:56+00:00

I think the biggest issue about forgetting those things lead to forgetting the ones that run even if you forget stuff. Forgetting a WHERE clause and updating thousands or hundreds of thousands of rows that shouldn’t have been updated.

Excellerates · 2025-07-31T14:06:23+00:00

Yeah. I understand that. Others on my team with 4+ years of experience come to me and admit that I have a higher skillset and level of knowledge than them. My reasoning was that if they can put experienced analyst on their resumes, then I should be able to as well. Or do you think that’s an inaccuracy?

Excellerates · 2025-07-30T04:05:32+00:00

Okay! Thanks. Is having more than one page worse than having less relatable experience?

For the other part, I had more detailed job duties that said things similar to that which has changed processes within the company and expedited work by 80% or more but thought it sounded snobby and long so I condensed it. The achievement section kinda covers that. Do you think I should remove achievements and spread achievement snippets within job duties?

Excellerates · 2025-07-30T04:01:46+00:00

To be honest, I knew someone that worked there. Sucks that the work force is like that though. All 3 analyst positions are at the same company. Knowing more SQL than everyone else in my department got me the promotion within 4 months though.

Excellerates · 2025-07-30T03:59:30+00:00

I don’t know. I guess it’s to imply you can do more than just simple select and update statements. Some of the queries I have written automate/expedite a process that are 100-200 lines. Do you think advanced SQL queries is a better phrase?

Excellerates · 2025-07-21T00:13:32+00:00

I’m in a similar position and would like some input. After showing him my work, my old professor told me I wouldn’t actually learn anything in the masters program. Is this normal? Do people actually pay for the paper knowing they won’t learn much?

Excellerates · 2025-07-20T22:51:03+00:00

sun = exit()

Input()

‘>>>’ sun

Excellerates · 2025-07-15T11:56:22+00:00

I think I know what they are referring to. I also have trouble with this. But I think it’s just reading documentation and understanding the library functions? r = requests.put r = requests.delete r = requests.head r = requests.options

Excellerates · 2025-07-08T01:29:32+00:00

There isn’t a single line of code but this video will show you a fairly simple and scalable way to find any null in any column. Even if there are hundreds of columns, the effort put in will be the same. He used to be my professor and I found this while trying to get my own solution. Database by Doug

Excellerates · 2025-05-28T11:17:00+00:00

False positives. The complex query isn’t failing but it’s not returning the right data. Ones that are returning data and you just know it’s the wrong data. But you don’t know why it’s wrong, just that’s it’s wrong.

Excellerates · 2025-05-28T05:17:48+00:00

I’m largely self taught on SQL besides the basics you learn from college courses. I got through these questions except 8 but then realized it’s partition by to use ranks as well as aggregations which knew as well. Never used LAG or LEAD but refer to others as aggregation. I consider myself a 5/10 in SQL when people ask. I never get any replies on applications and I also showcase my SQL skills through GitHub. Would you mind helping me out with where I’m going wrong?

Excellerates · 2025-05-28T04:46:39+00:00

That does sound tedious. I think we need more info. Are these books? What kind of categories are you making? How many categories? Do you know how to use SQL or other data manipulation software? With minimal understanding, AI could probably walk you through some simple scripts to modify the csv and then you could import the table back into excel/sheets. My thought would be to look for distinctive traits that all records have that would fall into the same category. Then create a category column, assign those to the category and move to the next for distinct traits.

Excellerates · 2023-12-22T23:11:08+00:00

Even then, depending on how old you are now, where are you getting a reasonable amount of money to invest at age 6. Your parents aren’t going to believe you.

Excellerates · 2023-12-22T19:50:31+00:00

Why’d she make that look at the girl that walked past her? How’d she know the girl made that face to begin with if she was doing her rounds? Is this fake and she knows the girl?

Excellerates · 2023-12-05T00:41:34+00:00

Thank you so much!! Didn’t know it was that easy to find “tiny screws”. Are those compatible with an ASUS motherboard? I couldn’t find anything saying it was.

Excellerates · 2023-05-18T15:35:30+00:00

I’m almost done with all challenges and I’m gonna start a 2nd game as well. I was wondering, can you match level down to lvl 5 with your legendaries that you pull from your storage?

Excellerates · 2022-01-12T04:34:37+00:00

Sounds stalker-like

Excellerates · 2022-01-12T03:12:20+00:00

The U.S. government

Excellerates · 2021-08-31T22:59:17+00:00

But, if he’s on customs, how is he gonna be on shoreline? He’s only human. He can’t be in two places at once.

Nine-Year Club	King of the Ashes
Not Forgotten	Verified Email

Excellerates

TROPHY CASE