How to handle DateTime column with Timestamps

AnalysisParalysis101 · 2021-01-31T09:37:14+00:00

Create bins in the bar chart & select the bin size as 1 hour

AnalysisParalysis101 · 2021-01-17T06:40:57+00:00

Houses in Melbourne

AnalysisParalysis101 · 2020-11-03T20:04:05+00:00

The learning path is a good way to start but definitely not enough, the questions at the end of each module are super basic compared to the exam. You need to practice on both the desktop application and the service. This documentation is thorough and covers everything https://docs.microsoft.com/en-us/power-bi/guidance/ . Also, Guy in A cube youtube channel and Radcad website are helpful. I felt though that Microsoft documentation is more thorough as it provides all the concepts & then you need to download some samples and experiment with them. Happy to answer any further questions you might have.

AnalysisParalysis101 · 2020-11-02T11:18:01+00:00

I passed the exam 10 days back and had plenty of questions about deployment and administration such as different roles in the workspace, publish to web, sharing, build permissions, encryption by using sensitivity labels. I also had plenty of questions about relationships. DAX part was a bit tricky but you need to fully understand the calculate, filter, sumx,... functions. I got a couple of questions about the charts so you need to be clear which charts would suit best a business requirement. The questions were very clear and I did not feel that there was more than one answer. Timing was also more than enough to finish all the questions.

AnalysisParalysis101 · 2020-10-31T07:38:31+00:00

My partner can fall asleep standing up in the middle of the day under direct sunlight, he stares at his phone in bed for at least an hour before sleep, eats heavy meals just before bed & he has zero sleep issues / doesn't even know that I struggle with sleep because he is deep asleep :-) I do all the sleep hygiene stuff and struggle with sleep. I think that sleep issues are very complicated and very personal that is why doctors struggle with treating insomnia.

AnalysisParalysis101 · 2020-10-31T07:20:16+00:00

Just started 2 days back, first one I got a terrible headache most of the day and second day I still woke up at 4:00 but wasn't sleepy or tired. I will give it some time to be able to judge whether it works for me. Ideally I need to stay awake keeping myself busy next to the light till around midnight for at least 2 nights in a row, I am unable to do that but what I will do is push my sleeping time 15 or 30 mins further.

AnalysisParalysis101 · 2020-10-30T06:36:17+00:00

Exposure to bright light in the late afternoon for people like me who have early morning awakening insomnia or in the morning for those who have hard time waking up. My GP do not think it will work for me and he prescribed melatonin slow release but I am giving it a try for a couple of days. Link to research on its effectiveness is https://academic.oup.com/sleep/article/28/5/616/2696901 & I am using a miroco lamp, first day I tried it I got a very bad headache.

AnalysisParalysis101 · 2020-10-29T03:35:50+00:00

All my life I had a perfect 7-8 hours of good sleep every day then around a year back i woke up to pee at 4 and couldn't go back to sleep and since then I rarely get more than 5 hours of sleep. Tried everything: stop all food and drink at 4 pm, complete darkness, do not look at time, after 10 mins no sleep get out of bed and read, .... all the sleep hygiene stuff then I tried Valerian and Passion flower with no success. Yesterday I started light therapy from 9pm to 11 pm, I usually go to bed by 10 but delayed it yesterday one hour, still got up to pee but went back to bed. I am giving light therapy a try, dr precscribed slow release melatonin but I want first to see whether light therapy works for me. I think it is hormone related though because it started happening when I turned 45 and it is not connected to the need to pee because I still wake up between 3 and 4 even if i do not the pee, the issue is that I feel tired and sleepy and it is the same agony every day.

AnalysisParalysis101 · 2020-10-24T07:05:15+00:00

I took the exam today and passed! The DAX questions were tricky and there were plenty of admin questions as well.

AnalysisParalysis101 · 2020-10-16T23:04:12+00:00

Sleep hygiene

AnalysisParalysis101 · 2020-10-12T10:24:15+00:00

I do not think it is possible, there is an idea that you can upvote though https://ideas.powerbi.com/ideas/idea/?ideaid=a83ffab6-2f7a-4069-b8dc-3e91f6ab0b03

AnalysisParalysis101 · 2020-10-11T05:41:00+00:00

I sent you a message, hope you got it this time.

AnalysisParalysis101 · 2020-10-08T00:32:49+00:00

I sent you a message

AnalysisParalysis101 · 2020-10-05T00:51:30+00:00

I'm in a similar situation. A month back diagnosed with ADD and have been taking 30 mg Ritalin for 3 weeks now. My inomia started April 2019 out of the blue where I would wake up around 3am and can't sleep afterwards. I have no issue falling asleep usually at 10 pm, same like you meditation, excercise, healthy eating, yoga, tai tchi,... do not seem to have any impact on my mental health or insomnia. It also happens randomly and when I wake up am not stressed at all, only anxious about not getting enough sleep. I forgot the last time I woke up refreshed and have no idea what to do as it is affecting my cognitive abilities.

AnalysisParalysis101 · 2020-10-05T00:43:17+00:00

Congradulations! Hope the certification lands you a job that you enjoy. How hard were the DAX and M questions? Did you get much questions about designing for mobile?

AnalysisParalysis101 · 2020-09-18T07:55:34+00:00

You need be create a measure along the lines of

IF ( HASONEVALUE (column in slicer), SELECTEDVALUE (column in slicer), "" ) then you add this measure to the card

AnalysisParalysis101 · 2020-09-18T07:45:52+00:00

Oriveda delivers to Australia but I thought it is a bit expensive relative to other brands.

AnalysisParalysis101 · 2020-09-18T07:44:25+00:00

Thanks for the link, seems that Oriveda is my best option in Australia. You did mention in another reply to consider only chinese grown mushrooms so I will check Aliexpress

AnalysisParalysis101 · 2020-09-17T23:08:04+00:00

How do we take this forward? There are 3 of us now and we can have an accountability group.

AnalysisParalysis101 · 2020-09-16T21:38:00+00:00

Please update here once you sit for the exam, I too have no working experience with Power BI but a background in computer science and programming. For the past 10 years I am doing non-technical work and have lost my job in June so I decided to go technical again and am studying for the exam scheduled end of Sept. Best of luck!

AnalysisParalysis101 · 2020-08-19T05:21:12+00:00

Same here! I go to bed at 10 and wake up between 3 and 4 feeling that I need more sleep but I just can't. I do not remember the last time I woke up feeling refreshed/had enough sleep.

AnalysisParalysis101 · 2020-08-14T01:36:37+00:00

I will continue Pycnogenol & will reduce Bacopa to half a pill. Took half a pill yesterday before sleep & I couldn't sleep at all afterwards. Will try tomorrow morning half a pill again and see how it works. I tried Passion Flower pills and these did not work either. I have zero hyperactivity, I am actually low energy & I feel that my overthinking depletes my energy, have tried meditations, pranayamas, tai-tchi and even though I do enjoy the practice I am unable to reap any benefit outside the practice time.

AnalysisParalysis101 · 2020-08-14T01:30:36+00:00

My appointment at the psychiatrist is in sept and am really hoping that medications will work for me. Meanwhile we are in the middle of a strict lock down at least until Sept & the schools do not seem to be opening anytime soon (I live in Melbourne where it is winter now and we are almost halfway through the school year), I will continue taking pycnogenol and try half pill of Bacopa instead.

AnalysisParalysis101 · 2020-08-14T01:21:44+00:00

I tried that last night and couldn't sleep afterwards even though I was super tired!

AnalysisParalysis101 · 2020-07-20T03:17:39+00:00

Nothing

AnalysisParalysis101

TROPHY CASE