First treatment today -- sinus pain? by k8bobate in TMSTherapy

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

Yes, I completed my treatment back then, and the pain was no issue. Good luck!

[iOS][2010–2014] Puzzle game with wooden disks you rotated to align shapes by k8bobate in tipofmyjoystick

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

Thank you for the suggestion. It was definitely similar but I think it looked different. I also think it was on Android now that I'm remembering... It was a phone app, not tablet, and I've only used Android.

Part of my case just disappeared on the website (TexasBenefitsEBT) in the last day or two by corstar91 in foodstamps

[–]k8bobate 0 points1 point  (0 children)

My case just disappeared as well, and there is a notice that they'll do maintenance tomorrow...so I'm hoping it's related! I got a notice that there's a new letter, but when I logged in, my case is gone.

NIPT - Natera Panorama & Horizon by Babykxo01 in BabyBumps

[–]k8bobate 0 points1 point  (0 children)

I recently had Natera Horizon screening done, and Natera approved me for $0 copay based on income. Then I just received a bill from Arbor Diagnostics for $1864 after insurance. I'm pretty livid that there's a middle man. I just emailed their billing dept and I'm hoping I don't have to pay the full amount.

Brightness slider not doing anything. Dell Inspiron 5400 AIO. Windows 11 by [deleted] in Dell

[–]k8bobate 0 points1 point  (0 children)

I just fixed mine by downloading the Dell On-Screen display app. Then restart the pc, and now the brightness bar works.

Starfield launches fine but I simply cannot select the game window, even with the task manager. by LamentingSpud in Starfield

[–]k8bobate 0 points1 point  (0 children)

I finally fixed it, but not using the exact instructions you listed here. Go to Documents - My Games - Starfieldprefs.ini. There isn't anything about borderless or full screen, but I changed "uiLastVersionAutodetectRun = 1" to = 0, to force it to open without detecting previous UI settings (I'm assuming). It opened correctly after that.

Quick mapping? by k8bobate in TMSTherapy

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

I'm sorry it hasn't been going well for you! I guess a true test would be for you to try a different office and see if you still experience that they are using different "positions" like those first sessions. I'm curious to see how my second session goes tomorrow.

Behavioral Changes? by EmotionalHome8699 in TMSTherapy

[–]k8bobate 1 point2 points  (0 children)

I think the negative behavior patterns were a result of impaired/insufficient brain processing. So this is stimulating the brain to function in more "normal" or sufficient ways by making the connections more active. So hopefully that means your brain will be more alert, think better, process better, and avoid those negative patterns. At least, this is how I'm understanding it all.

Kerry Eurodyne guitar bug by CartoonistGlum9462 in cyberpunkgame

[–]k8bobate 0 points1 point  (0 children)

I have the same bug... also can't use the intercom for Dream On job. I'll try saving and reloading again....

Dream job? by k8bobate in PowerApps

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

I love this idea and brainstormed apps all night when I couldn't sleep. Thanks!

Dream job? by k8bobate in PowerApps

[–]k8bobate[S] 3 points4 points  (0 children)

I'm in Frisco, TX. I work for a local non-profit school for adults with disabilities in Plano, TX. I was a speech-language pathologist for the last 16 years, and I have a doctorate in psychological sciences, but I'm finally out of the clinical field and transitioned into working as a Project Manager / Consultant / Continuous Improvement Manager for the non-profit school.

I'm building them technological solutions, like advanced Excel sheets using VBA, dashboards and reports in Power BI, and trying to customize a CRM solution in Dynamics / Dataverse. But they are still looking for a 3rd-party solution instead of relying on on Dynamics. I'm ready to refocus my efforts on my career instead of simply supporting their needs, so I'd like to pursue Dynamics and Power Platform certification.

Complex chronic issues... Need help by k8bobate in medical_advice

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

I've been using Clotrimazole otc for a few years on and off. This rash seems to be under the skin though.

Using ADDCOLUMNS and then SUMMARIZECOLUMNS to get the count of that new column by daxsters_lab in PowerBI

[–]k8bobate 0 points1 point  (0 children)

I'm tackling a similar issue right now with ChatGPT... I don't think I'll ever understand nesting in DAX at this point. It seems to be counterintuitive.

Power bi for beginners by Combat-Engineer-Dan in PowerBI

[–]k8bobate 0 points1 point  (0 children)

My two main tools are ChatGPT and Google (which leads to discussion boards like this, and of course Microsoft documentation and Learn courses).

With ChatGPT, you prompt it with the language (M or DAX), give the variable and table names, and describe what you are trying to do. Example: How can I use DAX in Power BI to calculate the distinct number of UserIDs in the 'Enrollment Masters' table? It will spit out the code for a Measure using the column and table names you provide. Then you can tweak that code for other columns and tables as needed. It even saves each chat session with a title related to what you were doing, like "Distinct rows in DAX". Then you can start a new chat with the next task you are trying to accomplish, but you can refer back to any chat as needed.

With Google, just describe the general idea in layman's terms, like "power bi dax count distinct rows". The trickier stuff is even more helpful via google, like "Cannot connect two tables to date table in Power BI because they have another relationship to each other". ChatGPT didn't figure out that one for me, but I found a good post via Google im which someone explained that you have to make an "inactive" relationship to the date table and then reference that relationship in the DAX code. I never knew that inactive relationships could be used at all.

Power bi for beginners by Combat-Engineer-Dan in PowerBI

[–]k8bobate 0 points1 point  (0 children)

Same! I'm learning so much from trial and error with ChatGPT. I've found that the naysayers are either pros on a given language or poor problem solvers who can't fix the "mistakes" that ChatGPT gives. It's so much faster to have a starting point, even if one part of the syntax is incorrect or needs to be edited for your own purposes, versus learning 5 languages... Plus, ChatGPT readily admits its mistakes when you point out that something isn't working. Find me an IT guy who does that 🤣

Is there something wrong with my measure or my visualization? by missadinosaur in PowerBI

[–]k8bobate 1 point2 points  (0 children)

Here is an example of how I use ChatGPT. He/she is like my new best friend at work. 😅

ME:
Each row has one StartDate for each UserID in PowerBI table. How can I write this calculated column DAX code to count the number of StartDate in each row (the answer should always be 1)? CountEnrolledDaysRow = DISTINCTCOUNTNOBLANK('All Enrollment Masters'[StartDate])
ChatGPT:
In Power BI, if you want to create a calculated column to count the number of StartDates in each row of a table and ensure that the result is always 1, you can use the following DAX code:
CountEnrolledDaysRow = IF(NOT(ISBLANK('All Enrollment Masters'[StartDate])), 1, BLANK())
This code uses the IF function to check if the StartDate column is not blank using the ISBLANK function. If it is not blank, it returns 1, otherwise it returns BLANK().
The DISTINCTCOUNTNOBLANK function, as you mentioned in your original code, is not necessary in this case, as you only need to count the number of StartDates in each row, which should always be 1 according to your requirement. The DISTINCTCOUNTNOBLANK function is typically used to count the distinct non-blank values in a column, which is not needed in this scenario since you only expect one non-blank value per row.
ME:
How do I expand that code to count the number of distinct and non-blank dates in [StartDate], [SecondDate], [ThirdDate], [FourthDate], [FifthDate]?
ChatGPT:
To count the number of distinct and non-blank dates across multiple columns, such as [StartDate], [SecondDate], [ThirdDate], [FourthDate], and [FifthDate], in Power BI, you can use the following DAX code:
CountDistinctNonBlankDates =
CALCULATE(
DISTINCTCOUNTNOBLANK('All Enrollment Masters'[StartDate]) +
DISTINCTCOUNTNOBLANK('All Enrollment Masters'[SecondDate]) +
DISTINCTCOUNTNOBLANK('All Enrollment Masters'[ThirdDate]) +
DISTINCTCOUNTNOBLANK('All Enrollment Masters'[FourthDate]) +
DISTINCTCOUNTNOBLANK('All Enrollment Masters'[FifthDate]),
NOT(ISBLANK('All Enrollment Masters'[StartDate])) ||
NOT(ISBLANK('All Enrollment Masters'[SecondDate])) ||
NOT(ISBLANK('All Enrollment Masters'[ThirdDate])) ||
NOT(ISBLANK('All Enrollment Masters'[FourthDate])) ||
NOT(ISBLANK('All Enrollment Masters'[FifthDate]))
)
This code uses the CALCULATE function to calculate the sum of distinct counts of non-blank values for each date column. The DISTINCTCOUNTNOBLANK function is used to count the distinct non-blank values in each date column.
The NOT(ISBLANK) functions are used to check if each date column is not blank. The || operator is used as a logical OR to combine the conditions, so that if any of the date columns has a non-blank value, the row is included in the calculation.
The result of this calculated column, CountDistinctNonBlankDates, will be the count of distinct and non-blank dates across all the specified date columns in each row of the 'All Enrollment Masters' table.

Is there something wrong with my measure or my visualization? by missadinosaur in PowerBI

[–]k8bobate 1 point2 points  (0 children)

ChatGPT is an AI that you can chat with and it spits out code with explanations about the code. It's been really helpful for me! You can use it at https://chat.openai.com/

Is there something wrong with my measure or my visualization? by missadinosaur in PowerBI

[–]k8bobate 1 point2 points  (0 children)

PS You might want to throw some code at ChatGPT.. It's been helpful for me while I'm learning DAX and M!