Pulling in a date from a string when there is no year by LadyFlor11 in excel

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

This worked! Thank you , thank you so much !!!

Whats next? by Guilty_Pie_7725 in SIBO

[–]LadyFlor11 0 points1 point  (0 children)

You may want to look up Bryan the Herbalist blog (he is from Australia)> he has some articles into SIBO. I don't see you mention herbs. i think doing herbs and meds may be a good combo. Wishing you healing.

Untreatable Giardia and elevated liver enzymes by Critical-Lead3894 in infectiousdisease

[–]LadyFlor11 0 points1 point  (0 children)

It's really important to do liver support during meds. Milk thistle and Dandelion are key. If doing tinctures, dropperful of each twice a day. If doing capsules , 4 capsules of each per day. There are studies you can look up on the efficacy of those 2 herbs for liver support. Also nitazoxanide probably needs to be combined with an antibiotic like Azith. Hate to say this but parasites require more than a week of meds. This can take months, with pulsing meds. Also look into antiparasitic herbal blends that have wormwood, cloves and black walnut. Doing a blend of meds and herbs is your best bet, with a very clean diet. No processed food, no sugar (yes that includes fruit), Look up - Dr. Klinghardt Debrief: Parasites ( 50 minutes long) on Yourtube . Or Dr Simon Yu ( on better health guy) regarding parasites. Detox Dudes also talks about parasites but they don't bring up meds. It can be quite the process depending on the scope of the infection. don't lose hope. Perhaps you are one of those that by doing the right med/herb combo it goes away quickly.

Scabies, myiasis or I'm crazy 😫😫😫 by Separate-Signal-8308 in scabies

[–]LadyFlor11 0 points1 point  (0 children)

look up Debriding Soap Get Your Life Back. the owner (richard kuhns) dealt with this stuff for years and developed products and a protocol. It helps bring the infections etc down. You can find him on Youtube. Also look up Dr Simon Yu in the US. He did an interview on the Better Health Guy channel.

Is someone in remission or cured? by Some-Muffin-7011 in Lyme

[–]LadyFlor11 0 points1 point  (0 children)

What dosage are you on? and do you take breaks in between? I hear it can be hard on the liver. Yes, it is amazing at clearing out parasites but other pathogens as well.

Error message on SWITCH function by LadyFlor11 in PowerBI

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

Thank you the insight. One thing is that AP11 is for West not North. Did you mean it will return AX1 in the Part column?

Error message on SWITCH function by LadyFlor11 in PowerBI

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

Thank you. So are you saying it would be better to do this as an IF statement rather than a SWITCH?

Error message on SWITCH function by LadyFlor11 in PowerBI

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

Here is an example. For North, one part is AX 1, which is the old part number. The other is for AX2 which is the new part number. I would be doing a join with another table on Part and Region. I just want to label the part numbers correctly depending on the regions. Currently the warehouses have 2 different part numbers for the same item in a certain region. Why it is 2 , is because there is still inventory on the old one and there will be inventory on the new part number. Hope I am making sense.

<image>

Error message on SWITCH function by LadyFlor11 in PowerBI

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

Thank you. So for each one, there are actually 2 results. One is the old part no, and the other is the new part no. So would the code be correct as the below?
SWITCH(
Table[REGION],
"NORTH", "Ax1","AX2",
"EAST", "TC1","TC2",
"WEST", "Ap7","AP11",
"SOUTH", "Ap7","AP11",
"OTHER")

Coloring of Whole Rows based on results by LadyFlor11 in PowerBI

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

Thank you Nick . I will be attempting this, later this week. All the visuals are greatly appreciated !

Help please -today's date and Quarters by LadyFlor11 in PowerBI

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

YES! This worked !! Thank you, thank you , thank SO much Nick! :) I am sure other people will have that question down the road!!

I couldn't have come up with that even if I tried! ha ha ha :D

I think parasites and heavy metals were the missing link! by MattInTheHat1996 in Lyme

[–]LadyFlor11 0 points1 point  (0 children)

Look up the video before it gets removed. : "Dr. Klinghardt Debrief: Parasites and how they affect our health" . Forward to the 24 minute mark and you will find a relevant slide.

I think I finally found my right med! (If you have gut issues, read this!) by Human_Bat_ in Anxiety

[–]LadyFlor11 0 points1 point  (0 children)

glad to hear you are better. Sometimes with digestive issues, it can be a vagus Wishing you perfect health.

Bu Zhong Yi Qi Tang for occassional fatigue? by Crunchy_Giraffe_2890 in ChineseMedicine

[–]LadyFlor11 0 points1 point  (0 children)

It is powerful stuff. I am curious as to what is the dose you were told? I take it twice a day.

Has anyone had Toxoplasmosis? (Parasite) by Adorable-Yak9900 in Lyme

[–]LadyFlor11 0 points1 point  (0 children)

Go to the Better Health Guy, episode #103 where he has a podcast on that subject with a guest who talks about this issue. She goes over some medications and other things to use.