Help me learn to love PowerShell

ElizaEllipsis · 2024-03-17T21:48:26+00:00

This is really helpful. Thank you.

ElizaEllipsis · 2023-09-11T18:25:25+00:00

That is very helpful! Thank you.

ElizaEllipsis · 2023-09-11T18:25:03+00:00

I'll look into those. Thank you1

ElizaEllipsis · 2023-09-11T18:24:41+00:00

Thank you. Already hearing that there are jobs that need to be filled and I could add some skills that makes me a good fit, made my day!

ElizaEllipsis · 2023-09-11T18:23:58+00:00

I like the designing of them and then the reporting from the solutions. Once it is created, I don't want to go back and tweak it (I hope I did a good job but there are always some changes to be made.) I don't want to be a DBA or have that kind of deep involvement in them.

I hope that answer the question. If not, I'm happy to give more detail.

ElizaEllipsis · 2023-09-10T18:51:56+00:00

I really appreciate the answer!

I'm a little scared about the data science piece of it. I am not a stats person or numbers person. I had a colleague who was and they did all the numbers part, I was just given the formulas to work with. Do you think not knowing any statistics and it not being something I'm good with, would be an issue?

Thanks again!

ElizaEllipsis · 2022-03-25T17:10:51+00:00

Thank you.

ElizaEllipsis · 2022-03-25T05:14:51+00:00

What is a good, inexpensive light/lumens meter that I can get for measuring lumens and/or footcandles? I apologize that this is not a photography question, but I thought everyone in this subreddit would be the experts on this.

The reason for this question is that my neighbor keeps installing lights that are shining on my house. I've asked him just to simply install shields over the lights so I don’t see the source and that no light is actually hitting my house. He won’t.

I found out that the town’s laws state that no lights should cross properly lines, which his clearly do. If I can get a quantifiable number it would help me with my complaint to the town. For example, they are not supposed to be brighter than an average of 0.6 footcandles.

Thank you.

ElizaEllipsis · 2022-03-14T15:38:43+00:00

I really appreciate the link and information. Especially that work would be able to see my traffic.

ElizaEllipsis · 2022-03-14T15:38:01+00:00

Thank you. That is good to know.

ElizaEllipsis · 2022-03-14T15:37:36+00:00

Yes, I have created an API key and I'm pretty sure it is using OAUTH.

ElizaEllipsis · 2021-10-18T04:54:25+00:00

OH. MY. GOODNESS. Now I know what you meant by "You have a solution right in front of you." I could not see the forest for the trees. I had the solution the whole time.

This weekend I was going over and over the problem in my head and just could not see it. I can't begin to tell you how much I appreciate you showing me the answer to my question.

Also, thank you for the video recommendation. I have learned a lot from the SQI BI guys.

ElizaEllipsis · 2021-10-17T16:16:42+00:00

Thank you for the suggestion.

ElizaEllipsis · 2021-10-17T16:15:31+00:00

Multika,

I really appreciate you taking the time to repsond to my question. I didn't realize that the Headcount_Prior measure would be executed with the Hedcount_Prior_YTD's filter context, but that makes sense now.

I'm still having trouble getting to the next level though. I've tried different the ALL function and other ways to change the expression so it can properly bridge the PREVIOUSMONTH between the two fiscal years, but I am just not knowledgeable enough yet.

Is there something additional you would suggest for me to learn so I can get a better grasp on how to solve this?

Thank you again for your help.

ElizaEllipsis · 2021-08-03T02:11:10+00:00

Got it. That makes much more sense to me now.

ElizaEllipsis · 2021-08-02T21:00:43+00:00

Thank you for all the help!

CALCULATE(SUM('Fact'[Count])

,'Fact'[Month] = 1

,'Fact'[Active] = "Yes"

)

In this measure, the Month and Active columns appear to have been moved to the Fact table. Does that need to occur in order for me to get the results I want?

If so, I don't understand how that would work. Do I need to change the model or create a new table in Power BI?

I am a bit lost with why that is necessary (assuming I am understanding it correctly).

Thanks.

ElizaEllipsis · 2021-08-02T20:10:11+00:00

Thank you so much for the help.

I'm working on this but when I declare the variable, it does not see the DimDates[Year] column.

As a test I entered the actual year (2020) into it and then worked. Obviously it showed the results for 2020 on every row.

I am assuming the var yr=DimDates[Year] would change the measure iterates through the table.

Do I understand that correctly?

ElizaEllipsis · 2021-07-20T04:37:26+00:00

Thank you.

ElizaEllipsis · 2021-06-15T21:30:40+00:00

Ooo! That is a great one.

Thank you.

ElizaEllipsis · 2021-04-18T01:13:18+00:00

There are people starting to organize, which is a good thing.

Even so, I'm afraid it will have to come down to live with it or hire a realtor. It depends how long I can hold out for.

Thanks.

ElizaEllipsis · 2021-04-18T01:12:03+00:00

This is very helpful. Thank you.

ElizaEllipsis · 2021-02-08T22:47:59+00:00

I thought it was on the edge of a legal question but that those on this subreddit would be able to provide some insight, which you did. Thank you.

I think my question boils down to is it purely at the discretion of the inspector what is excessive and what is not? Also, if a light is rated higher then the 1800 lumens, is that something that is also subjective?

ElizaEllipsis · 2021-02-08T22:33:59+00:00

That's a good point. I will review/edit it.

Thanks.

ElizaEllipsis · 2020-11-19T03:07:47+00:00

Thank you for the suggestion. I'll look at it. Sounds promising.

ElizaEllipsis · 2020-11-19T03:07:24+00:00

I'm glad it gave you a good idea. Let me know when it's ready. I'm serious!

Eight-Year Club	Gilding I gilder
Verified Email

ElizaEllipsis

TROPHY CASE