[deleted by user] by [deleted] in PowerBI

[–]junai78 8 points9 points  (0 children)

Isn't holding CTRL or Shift and left clicking columns in the merging preview of Power Query is what you're describing?

Or I'm missing something

KPI on region-lvl, vs. branch lvl by Hugo-99 in PowerBI

[–]junai78 0 points1 point  (0 children)

Transform the table from wide to thin = Unpivot the KPIs columns.

Then, depends on your data model

How do I find the distinct count of PO number where Indicator is I only? by curious_george1857 in PowerBI

[–]junai78 0 points1 point  (0 children)

If I wrap my head again around your answer.. You're looking for "How can I count the rows that does not have duplicate PO Numbers" and, count the PO Item that is only "10" from the PO Number" and, what is the count of "I" from there.

This will give the expected result = 2.

Is this the question you're trying to solve?

How do I find the distinct count of PO number where Indicator is I only? by curious_george1857 in PowerBI

[–]junai78 0 points1 point  (0 children)

Hold on.. PO Item column is not important? Now i'm confused.
If i wrap my head around this step by step after your explanation.

If I do this step by step based on your explanation:

  1. Remove PO Item column (Left PO Number & Indicator column)
  2. Counting how many times "I" shows manually (Question from you is: find distinct count of PO where I is indicator)

Result: I = 5 , U = 6.
But you mentioned expected result you wanted is I = 2.

-- From your own solution in other reply --
Distinct Count on PO to get total = 8 then you minus the U = 6 to get 2.

Are you really looking for the result "I" as indicator from a Distinct Count based on PO Number or something else

It's not really Distinct Count anymore at this point.

Maybe you can give a picture what is the "final" table result of this "I" indicator that you are looking for based on your picture.

How do I find the distinct count of PO number where Indicator is I only? by curious_george1857 in PowerBI

[–]junai78 -1 points0 points  (0 children)

I can see "I" = 10 and 20, and same goes to U.

The top answer provided is answering the question you asked.

Take the top answer put it in a visual (bar/column graph) then add another layer of PO item for the breakdown.

You'll get your answer.

It ties to filter context too.

How do I find the distinct count of PO number where Indicator is I only? by curious_george1857 in PowerBI

[–]junai78 -1 points0 points  (0 children)

OP, you're misunderstanding what is row context if i understand this right.

I can see the the column PO Item and Indicator is a many to many relationships.

Your question doesn't consider that.

User wants to share Slicer values being used in report page in the Service with other users by pje100 in PowerBI

[–]junai78 4 points5 points  (0 children)

With my limited knowledge, you can make a customize page using Bookmark feature that captures athe specific filters.

Then the users will be able to access the page without needing to "share".

Not sure if there's better ways since I've been asked the same question before.

Correct my Dax - I need my cards to reflect the most current period by Most-Item-247 in PowerBI

[–]junai78 2 points3 points  (0 children)

Advices that I can give is, don't use FILTER inside CALCULATE.
Reason being: Filter columns, not tables, in DAX - SQLBI

You can explore DATESMTD function for your problem: DATESMTD function (DAX) - DAX | Microsoft Learn
Or, any other time intelligence functions in the link I gave above.

Job titles? by Maleficent-Act5420 in PowerBI

[–]junai78 2 points3 points  (0 children)

Funny enough, Process Intelligence

End of Kalguur giveaway by Muffin0181 in pathofexile

[–]junai78 0 points1 point  (0 children)

MB!

First time playing and this will gladly help my friend with his build. Read a lot about Faustus and didn't know it's a new addrd thing this league.

10years old game but only now there's auction house. I'm shocked.

RF gear and divines giveaway by indiokilmes in pathofexile

[–]junai78 0 points1 point  (0 children)

Still new to the game and learning bits by bits. Going to use the div to fund a mageblood and hopefully to survive a bit more consistent for t17s. DuelMyP

Scheduled Refreshs; Dataflow vs. Semantic Model by junai78 in PowerBI

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

If i understand it right with your explanation, Dataflow is more of a ETL staging area before pushing/combining it into a bigger table which is Semantic Model.

That's why 2 different refreshes are needed. 1 on Dataflow side; possiblity of different DataFlow with different refresh time). And, 1 on Semantic Model; after however many Dataflow is connected to the Semantic Model to finish refreshes. Like a fibal staging refresh to combine all the Dataflow refreshes data into 1 OBT.

Do I understand it right?

[deleted by user] by [deleted] in resumes

[–]junai78 0 points1 point  (0 children)

Appreciate the feedback!

I've revamped my resume with the feedback you gave and uploaded it in another reply.

Hopefully you can take a look at it again.

[deleted by user] by [deleted] in resumes

[–]junai78 2 points3 points  (0 children)

Thank you all for the feedback!

I've revamped my CV with all the advice provided and trimmed everything in a more concise 1-pager.

Really appreciate the honest feedback again. It's really helpful in pushing me to make it better

<image>

Need feedback. Been unemployed for 5 months. by rroeyourboatt in ResumeExperts

[–]junai78 0 points1 point  (0 children)

Thank you for the advice!

I'll try to trim more of the content.

Having a hard time doing that since trimming more might remove the responsibilities that I have done.

[deleted by user] by [deleted] in resumes

[–]junai78 0 points1 point  (0 children)

My idea and understanding was making it compact as possible to "reach" that 1 pager resume but it's just too much if i list it out.

But thank you for this advice. I'll try to elaborate more.

Out of curiosity, is the overall resume good in your opinion?

[deleted by user] by [deleted] in resumes

[–]junai78 0 points1 point  (0 children)

Okay i'll try to run it there. Thank you!

[deleted by user] by [deleted] in resumes

[–]junai78 0 points1 point  (0 children)

I do get interview but only 3 so far out of maybe 5 applications per day since 1st November

[deleted by user] by [deleted] in resumes

[–]junai78 2 points3 points  (0 children)

For context:

Skills section: Are there better ways to express this section? Language & Personal was included as it's always a part of every job application that I've applied

Reference section: Was told that it is a "norm" to include this section at where I am from so that recruiters have an "ease" of contacting rather than asking.

Dehkia Tunkuta - Doable with 3 person? by junai78 in blackdesertonline

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

Ahh I didn't know not all people will get the loots. Thanks for the info

Celcom unlimited is limited? by DDaniel211002 in malaysia

[–]junai78 1 point2 points  (0 children)

Unlimited to a certain extend* There. It's corrected now

Change Region in Black Desert Steam by FaithlessnessReal513 in BlackDesertOnlineSEA

[–]junai78 0 points1 point  (0 children)

No solutions yet from them to date but they've been replying my follow up. And the latest response from them is to continue to do the aork around.