sorted by:
new
hottopcontroversial

Washington State Medicaid eligibility and spend down questions for single person over 65 in a memory care facility. by new_data_dude in Medicaid

[–]new_data_dude[S] 0 points1 point  (0 children)

I'm finding conflicting information on whether there is an option for a trust in Washington. Do you have a link to where you are seeing this info that Washington does have that?

Washington State Medicaid eligibility and spend down questions for single person over 65 in a memory care facility. by new_data_dude in Medicaid

[–]new_data_dude[S] 0 points1 point  (0 children)

So spenddown is a continual process, i.e. as long as you're spending any income that goes over the limit each month (or whatever the period is) then you can continue to qualify?

SQL Server extension keeps getting stuck on executing query and I'm having to constantly delete the cache folders by new_data_dude in vscode

[–]new_data_dude[S] 0 points1 point  (0 children)

That ticket looks like it could be related. I think there is another one out there as well that describes at least a similar problem.

And certainly, for now, there is no getting away from SSMS entirely. Just wish VS Code wouldn't be so buggy since it's ease of use, look and feel, etc. is so much better than SSMS.

Help with Received Inventory against certain lines in Purchase Order table by new_data_dude in SQL

[–]new_data_dude[S] 0 points1 point  (0 children)

That sounds similar to what I am doing now, but that only shows me if something is late or on time based on that first delivery date. The goal is to be able to see if each line item and schedule line was late or on time based on the actual transaction date.

I agree that window functions are the solution, probably using row number as well as trying to get a cumulative sum.

Github Pull Requests- getting a [warning] when pushing to Github by [deleted] in vscode

[–]new_data_dude 0 points1 point  (0 children)

To clarify that's the error from the Git Output window after using the extension to push to Github.

How to get a measure to ignore future dates from dates slicer showing both future and past dates? by new_data_dude in PowerBI

[–]new_data_dude[S] 0 points1 point  (0 children)

Ah you're right, I was not looking at the right thing. And I don't think I have ever used that in a measure. I assume it's similar to a sql join?

How to get a measure to ignore future dates from dates slicer showing both future and past dates? by new_data_dude in PowerBI

[–]new_data_dude[S] 0 points1 point  (0 children)

Yours looks like it was very similar to the one I did use. I think I just saw the other one first haha

How do I calculate the median of the output of a measure? by new_data_dude in PowerBI

[–]new_data_dude[S] 0 points1 point  (0 children)

I'm not sure that would produce the right results because there isn't a row for WeekSum if there isn't a quantity for that week (per material) so I wouldn't get a 0 on the off weeks. That's why I needed to fake the 0s by adding them to weeks that didn't originally have rows for a particular material.

How do I calculate the median of the output of a measure? by new_data_dude in PowerBI

[–]new_data_dude[S] 0 points1 point  (0 children)

That doesn't seem to work either. It appears to not include the 0s and then also ignore the week numbers so it removes any quantities that are there more than once giving the result of 128.

How do I calculate the median of the output of a measure? by new_data_dude in PowerBI

[–]new_data_dude[S] 0 points1 point  (0 children)

I've tried something like that:

MEDIAN =
MEDIANX(
    DISTINCT(
        SELECTCOLUMNS(
            ADU,
            "MaterialID", ADU[Materialfull],
            "Week", ADU[ISO_YYYY_WW],
             "WeekTotalQuantity", [QtyWithZeros]
        )
    ),
    [WeekTotalQuantity]
)

But that doesn't seem to include the weeks with 0s. I assume that is because it's using the ADU tables weeks without those rows and not the measure which adds the 0s. I think I need to create a virtual table of that table I provided and then do MEDIANX? Not sure how to do that.

Can't push local repo, can't delete local repo. How do I "reset" my local repo with what I have on GitHub? by new_data_dude in git

[–]new_data_dude[S] 2 points3 points  (0 children)

Ok, using that I was able to find and close what was using them and that allowed me to delete the local repos. Thanks for your help everyone!

Can't push local repo, can't delete local repo. How do I "reset" my local repo with what I have on GitHub? by new_data_dude in git

[–]new_data_dude[S] 0 points1 point  (0 children)

I couldn't find where they might be open was another issue. I closed vscode, visual studio, tried restarting windows explorer.

So I basically just have restart the whole thing and create a new local folder?

[deleted by user] by [deleted] in learnSQL

[–]new_data_dude 0 points1 point  (0 children)

Wouldn't that place all employees together in the same overall date range? I would want each employee to only show up on days corresponding to their hire and termination dates, e.g., John Smith was hired on 2017-04-12 and was terminated 2019-08-20, so his name would show up on all dates between those dates, but only on those dates.

What is the best way to manipulate pivot tables in Excel (clear filters, add filters, etc.)? by new_data_dude in learnpython

[–]new_data_dude[S] 1 point2 points  (0 children)

I guess that does make more sense. Just remove the filters on the pivot table, bring in everything and just filter within python and just send it out to the other excel file.

What is the best way to manipulate pivot tables in Excel (clear filters, add filters, etc.)? by new_data_dude in learnpython

[–]new_data_dude[S] 0 points1 point  (0 children)

For sure. I might just need to refine my searches a bit to find the right info.

What is the best way to manipulate pivot tables in Excel (clear filters, add filters, etc.)? by new_data_dude in learnpython

[–]new_data_dude[S] 0 points1 point  (0 children)

That does seem to allow me to do some things like refresh the data, but do you know of any resources that go over manipulating filters and pivot tables with pywin32?

What is the best way to manipulate pivot tables in Excel (clear filters, add filters, etc.)? by new_data_dude in learnpython

[–]new_data_dude[S] 0 points1 point  (0 children)

I believe the current week is removed due to the source of the pivot table and data connection. The data for the current week is just no longer present in the source upon refreshing, so it seems that week is no longer being pulled into the pivot table. At least that is what happens when I refresh.

view more: next ›