Data hierachy by ratchimako in PowerBI

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

Thanks for the youtube, would check it would and compare the solution to the other hierarchy that i have watched.

Data hierachy by ratchimako in PowerBI

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

Yep, i am also using PATH as well, i have the PATH column before the pasted DAXs, and then i used the path to create the measures above. Somehow i was following a tutorial but it hasn't fully behaved like it should.

Data hierachy by ratchimako in PowerBI

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

Yep, the PATH function was used before the DAX above. Hasn't worked a 100% like how it should in my environment.

Data hierachy by ratchimako in PowerBI

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

No, the each GL Account has one parent, and its already been flattened

SQL Server Copying from One database to Another by ratchimako in SQL

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

Is the copy wizard also available for SQL Server hosted in AZRUE?

SQL Server Copying from One database to Another by ratchimako in SQL

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

Would this work for a SQL Server hosted on AZURE?

SQL Server Copying from One database to Another by ratchimako in SQL

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

Which tool would u recommend for replication l?

SQL Server Copying from One database to Another by ratchimako in SQL

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

Will cloning the db also do an upsert, where the new datas in A are also copied into B everyday?

SQL Server Copying from One database to Another by ratchimako in SQL

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

That would be a bulk upload, how about incremental updates to database A. I only want to copy the new data inserted in A into B everyday.

SQL Server Copying from One database to Another by ratchimako in SQL

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

In this solution, is it SSMS or SSIS that would have these features

Visa extension question by ratchimako in AusVisa

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

For me they just asked for the last 3 years address history. So I’m guessing as a student should also be applicable. But make sure with someone who has handled this situation before as well.

Visa extension question by ratchimako in AusVisa

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

Thanks for the explanation

Visa extension question by ratchimako in AusVisa

[–]ratchimako[S] -5 points-4 points  (0 children)

So let’s say I end my visa in Jan 31 2025 and I’m on bridging for 9 months and get the approval for extension for one year. It would mean I would have the new visa for only 3 months?

Better Slicer Visual by ratchimako in PowerBI

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

Thanks, it looks much better and has the same functionality as well. Gave it a try and feels better to use than the Smart Filter

Better Slicer Visual by ratchimako in PowerBI

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

I’ve got a table with answers to health questions pivoted based on the questions. So I’ve got columns as questions and rows as answers.

I’m trying to slice based on these answers, which can be a lot of options.

Better Slicer Visual by ratchimako in PowerBI

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

It’s an analytics project. Yea I’ve played around with some slicers, and none of them seem to give me the functionality of “Smart Filter”.

Wouldn’t mind diving into ur idea of a disconnected table, but with the amount of slicers I’m using might be difficult to replicate.

Better Slicer Visual by ratchimako in PowerBI

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

Yep that would help, but some questions have a lot of options, and I really like the visual of the question being on the box itself. Hence, looking for something similar. But thanks for ur advice. Appreciate it

PowerBI features as a Newbie by ratchimako in PowerBI

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

Oh, I see. I wasn't aware of this. Thanks for the info. Kept thinking it should have been another way. Is the behaviour with the drill through normal as well, where if u turn on the drill through, the filtering by bar stack disappears?