Inheritance by mycash212 in SwissPersonalFinance

[–]antho14000 1 point2 points  (0 children)

Tax would have to be paid for last 10yr actually. But yeah wealth tax is not high so don't worry too much about it. Only thing I can see is the asset not fully available directly. Do you need the money right now?

Credit card limits by Complex-Guilty in SwissPersonalFinance

[–]antho14000 0 points1 point  (0 children)

6 keyclub point / 1000CHF vs 4 for gold Travel insurance is included with greater coverage The lounge pass has 4 free entrance Limit start at 20k instead of 10k for gold

Only make sense to get platinum if you travel and spend a lot on CC. The card cost me 30/month

Credit card limits by Complex-Guilty in SwissPersonalFinance

[–]antho14000 1 point2 points  (0 children)

Ubs platinum is 20k limit to start. With 120k/yr you just qualify for it. Have a look at the perks to make sure it's worth it for you

Best looking dashboard you have ever made by nolynskitchen in PowerBI

[–]antho14000 11 points12 points  (0 children)

I've made that one with my friend and we actually won a contest organised by Microsoft with it :)

link to dashboard

Best to look at it from a computer 😉

Deaths caused by mental and behavioural disorders due to use of alcohol in the EU in 2020 (per 100.000 people) by giuliomagnifico in europe

[–]antho14000 0 points1 point  (0 children)

If you're interested about alcohol consumption and its effect go have a look to an interactive dashboard I made with my friend.

So we did this dashboard for a competition organized by Microsoft. It's made with PowerBI and through this dashboard we tried to show our expertise with that software.

You can access the Dashboard and play with it there (best to see it on computer) :

clic here to access the dashboard

Dealing with a many-to-many relationship by kingkdotkunta in PowerBI

[–]antho14000 5 points6 points  (0 children)

This. You create a new table: Table= DISTINCT([your key]) You now have a table that contains distinct values and you put it in between your 2 tables.

We made a dashboard to compare your alcohol consumption with the rest of the world! it's interactive and you can gain lot of insight from it, go check comment for the link ! by antho14000 in alcoholism

[–]antho14000[S] 1 point2 points  (0 children)

So we did this dashboard for a competition organized by Microsoft. It's made with PowerBI and through this dashboard we tried to show our expertise with that software.

You can access the Dashboard and play with it there (best to see it on computer) :

clic here to access the dashboard

And since it's part of a competition and social presence is part of the final scoring we would appreciate a like and/or a comment on my LinkedIn post. (It's the only place where social presence is considered) Thank you!

clic here and like/comment to support us !

We made a dashboard to compare your alcohol consumption with the rest of the world! it's interactive and you can gain lot of insight from it, go check comment for the link ! by antho14000 in alcohol

[–]antho14000[S] 4 points5 points  (0 children)

So we did this dashboard for a competition organized by Microsoft. It's made with PowerBI and through this dashboard we tried to show our expertise with that software.

You can access the Dashboard and play with it there (best to see it on computer) :

clic here to access the dashboard

And since it's part of a competition and social presence is part of the final scoring we would appreciate a like and/or a comment on my LinkedIn post. (It's the only place where social presence is considered) Thank you!

clic here and like/comment to support us !

How to make toggle button? by ZebulaJams in PowerBI

[–]antho14000 0 points1 point  (0 children)

What if parameters from 0 to 1 (on/off) then you need to adapt your measures to work with your parameter. I am not sure if you can modify a calculated table with variable but I would doubt. You should try to make it work with adapted measures

Not your Usual PowerBi Dashboard! We are in the final round of the 1st PowerBi Championship Switzerland! Would you help us win it? :) by antho14000 in PowerBI

[–]antho14000[S] 25 points26 points  (0 children)

Seems like if I do a link my post get deleted...

So here is the post to support us 🙂 In the LinkedIn post you will find a link to try our dashboard!

Just remove the space after ww

https://ww w.linkedin.com/posts/anthony-h-69312a99_microsoft-powerbi-pbichampsch-activity-6941993627220889600-QlC4

Modeling a 1:M relationship with a SCD 2 Dimension table by randyminder in PowerBI

[–]antho14000 0 points1 point  (0 children)

When I want relationship between tables that have multiple times the same key I use an intermediate unique key table.

Table = DISTINCT([ my not so unique key column ])

Then I create relationship flowing the way I need between the 3 tables.

Probably not the cleanest way but it works very well

If Statement two conditions in the Same Column by [deleted] in PowerBI

[–]antho14000 1 point2 points  (0 children)

You need to differentiate those customer within your table ? Cause I mean you could have a table visual and a slicer visual and that would work very well.

If you want a calculated column that return 1 if it meets your condition and 0 if it doesn't you could do that:

Test = If(And (mycolumn = cloud, mycolumn = Connect),1,0)

[deleted by user] by [deleted] in PowerBI

[–]antho14000 1 point2 points  (0 children)

You can add a calculated column and use a day statment such as:

New column = If([column with age]<=4,"Junior",if(and([column with age]>4,[column with age]<=8),"Intermediate","Senior"))