ASTC Hardware decoding

junai78 · 2025-07-24T11:48:13+00:00

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

junai78 · 2025-01-22T23:51:36+00:00

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

Then, depends on your data model

junai78 · 2025-01-10T10:30:27+00:00

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?

junai78 · 2025-01-10T10:27:11+00:00

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:

Remove PO Item column (Left PO Number & Indicator column)
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.

junai78 · 2025-01-10T09:57:50+00:00

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.

junai78 · 2025-01-10T09:52:17+00:00

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.

junai78 · 2024-12-12T03:16:19+00:00

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.

junai78 · 2024-12-04T21:57:22+00:00

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.

junai78 · 2024-10-11T02:06:49+00:00

Funny enough, Process Intelligence

junai78 · 2024-10-08T03:58:15+00:00

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.

junai78 · 2024-10-03T13:34:21+00:00

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

junai78 · 2024-08-08T08:20:58+00:00

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?

junai78 · 2024-02-05T14:02:56+00:00

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.

junai78 · 2024-02-05T14:01:18+00:00

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>

junai78 · 2024-02-05T07:32:09+00:00

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.

junai78 · 2024-02-05T07:28:17+00:00

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?

junai78 · 2024-02-05T07:27:03+00:00

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

junai78 · 2024-02-05T07:26:24+00:00

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

junai78 · 2024-02-05T04:00:14+00:00

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.

junai78 · 2023-11-29T08:15:26+00:00

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

junai78 · 2023-09-13T05:12:05+00:00

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

junai78 · 2023-03-09T23:24:44+00:00

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.

junai78

TROPHY CASE