This was great. Hope to see more Power BI tips from you.
@qiancasper3 жыл бұрын
It's really helpful for my current situation. Now I'm learning how to to implement this into realistic job flow
@NPT3 жыл бұрын
Awesome to hear Casper!
@gauravsukhadia6382 жыл бұрын
Same here learning how to implement this into real business problem. 🙂
@shreyakhullar29194 жыл бұрын
Excellent description of outliers...Thanks !!
@jazzista19676 жыл бұрын
Great explanation of outliers..will use this technique at work..
@NPT6 жыл бұрын
Thanks jazzista1967, glad to hear the explanation is useful. 😀
@jazzista19676 жыл бұрын
Thanks for posting. Just subscribed to your channel. Your outlier technique gave me an idea on how to detect differences in my accounting accruals specially on the swings of values month over month! Great channel.
@feng36253 жыл бұрын
very wonderful piece. Thank you very much!
@NPT3 жыл бұрын
You're welcome Feng!
@rauljimenez54854 жыл бұрын
Great explanation and tools!! Another interesting analysis could be the cost per sq.ft The cost could be related to the size, but looking at it as $/sq.ft might be more meaningful. I know this is just an explanation of the tools, just sharing the thought. Thank you very much for the video, it is very useful!!!
@NPT4 жыл бұрын
Great observation Raul! I'm glad you find the videos helpful.
@brandonwarfield56119 ай бұрын
Finally found something I understand but can't use because app no longer exist in power bi. 😭😭
@pedja25182 жыл бұрын
Great video! Thnx
@NPT2 жыл бұрын
Glad you liked it!
@a.amiracle25794 жыл бұрын
Great explanation, thank you!
@dashbyron85483 жыл бұрын
you probably dont give a shit but does any of you know a method to log back into an instagram account? I somehow forgot the login password. I would love any tips you can offer me.
@coengiovanni47693 жыл бұрын
@Dash Byron Instablaster =)
@dashbyron85483 жыл бұрын
@Coen Giovanni I really appreciate your reply. I found the site through google and I'm waiting for the hacking stuff now. Seems to take quite some time so I will reply here later when my account password hopefully is recovered.
@dashbyron85483 жыл бұрын
@Coen Giovanni it did the trick and I actually got access to my account again. I'm so happy:D Thank you so much, you really help me out !
@coengiovanni47693 жыл бұрын
@Dash Byron glad I could help :D
@angelmaravilla4708 Жыл бұрын
That visual (Power Bi Outliers Detection) is not longer available in Power Bi, do you knwo why or what can I do to get it??? PD: Great video
@user-ug5wk2cv5f Жыл бұрын
Outliers detection plot is not present in power bi
@guustvandijck45055 жыл бұрын
Hi Nathan! Great post. Just one question; I´m actually just interested in the outliers and would therefor like to use this visual as a drillthrough/ filter for another visual. So I would like to press on the datapoint of a particular outlier, so that it filters a table that is in the same page. Do you know if this is now possible? Really looking for the interaction with other visuals here...
@toshiehabu47553 жыл бұрын
To be able to use the Outlier detector, the PowerBI has to install 3 packages. But I couldn't DMwR install. So it didn't work. DmWr seems removed from R. Does this visual (Outlier detector) still work?
@jaydobya4 жыл бұрын
How were you able to have a non-aggregated column in your measure formula ?
@solomonrobert675 жыл бұрын
Excellent description of Outliers. Have learnt a new stuff which will help me. Have a doubt here in the DAX you have written for ZScore. The DAX starts with ([Market Value]) which do not have a table mentioned to it. I have an exactly similar scenario which I am writing the same DAX. But unable to execute it. I get the below error: ZScore = ('PSC_Tokyo MoU'[Deficiency Count] - AVERAGE('PSC_Tokyo MoU'[Deficiency Count]))/STDEVX.S('PSC_Tokyo MoU'[Deficiency Count]) Error: Too few arguments were passed to the STDEVX.S function. The minimum argument count for the function is 2 Can you please help?
@NPT2 жыл бұрын
I'm sure you've worked it out by now. But it looks like you need to add the table reference to the STDEVX.S function. Maybe like this... STDEVX.S(RELATEDTABLE(PSC_Tokyo MoU), PSC_Tokyo MoU[Deficiency Count])
@suryasurya39056 жыл бұрын
Hi need help on DAX,I have a data of columns names as ,student name and status(pass/fail).so need to calculate the pass% and fail% for total ppulation of students with the use of dax funftion.Can any one help me to get the dax function.
@NPT6 жыл бұрын
Hi Kamesh, since you already have the pass and fail status, I would do a count of each status as a separate measure and then use the measure to divide by a COUNT of all records. So one measure that counts PASS, another that counts FAIL, and then use the results as the numerator over the total count.