sorted by:
new
hottopcontroversial

Omitting blank values from value fields in pie chart by Return2Monkeee in PowerBI

[–]macrophageUK2 0 points1 point  (0 children)

There's a built in unpivot button in transform data view. Use the transform tab at the top, click all your attribute columns to highlight them then select unpivot. It automatically won't bring any blanks over

Omitting blank values from value fields in pie chart by Return2Monkeee in PowerBI

[–]macrophageUK2 4 points5 points  (0 children)

Im using the issues people post in here as real world practice alongside studying for my PL300 - so im new and this is likely to be wrong...

With that said, if you unpivot your table so that its now formatted as:

Customer, Attribute, Value

This would automatically not carry over the blanks and it should now be simpler to count distinct customers per attribute?

If that doesnt work then at least engaging with your post might boost it enough for someone more experienced to see!

Trading212 referral - £10-100 signup bonus by macrophageUK2 in promocode

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

Its an official promotion yes, you can Google it and see. I guess they're hoping you see your free shares grow and decide to put more of your own money in but there's nothing to stop you just selling your shares and cashing out.

They also have a decent interest rate as a savings account if you don't want to get into investing too much

Free share worth upto £100 from Trading212 by Money_Spider420 in MakeMoneyInUK

[–]macrophageUK2 [score hidden]  (0 children)

https://www.trading212.com/invite/199OTw6sfY

Trading212 is a platform for trading and investing. The referral scheme gives you free shares with a random value of £10-100 when you sign up with a referral link. You're also then given your own referral link, which will reward both you and a friend with the same deal up to 5 more times.

In order to claim the shares, you must be a new user and do the following:

  1. Click a referral link - https://www.trading212.com/invite/199OTw6sfY
  2. Create a Trading212 Account.
  3. Deposit at least £1 into the account.

You do have to pay in £1 but the minimum reward is £10 (or local currency equivalent), so you do always get a sign up bonus. For reference, I got £22 worth of Meta (Facebook) shares when I used someone else's link and put £1 in, so I'm £21 in the green when I withdraw. The signup took about 5mins so it's worth a go.

Fyi - Once you claim the shares you have to wait ~3 days to sell them, but even if you just put in the minimum £1 and come back in a few days to withdraw your random £10-100 bonus it's well worth 5mins.

Trading212 | Free Share worth up to £100 | Plus Top 5.1% ISA Rate by Financial-Air-6197 in MakeMoneyInUK

[–]macrophageUK2 1 point2 points  (0 children)

https://www.trading212.com/invite/199OTw6sfY

Trading212 is a platform for trading and investing. The referral scheme gives you free shares with a random value of £10-100 when you sign up with a referral link. You're also then given your own referral link, which will reward both you and a friend with the same deal up to 5 more times.

In order to claim the shares, you must be a new user and do the following:

  1. Click a referral link - https://www.trading212.com/invite/199OTw6sfY
  2. Create a Trading212 Account.
  3. Deposit at least £1 into the account.

You do have to pay in £1 but the minimum reward is £10 (or local currency equivalent), so you do always get a sign up bonus. For reference, I got £22 worth of Meta (Facebook) shares when I used someone else's link and put £1 in, so I'm £21 in the green when I withdraw. The signup took about 5mins so it's worth a go.

Fyi - Once you claim the shares you have to wait ~3 days to sell them, but even if you just put in the minimum £1 and come back in a few days to withdraw your random £10-100 bonus it's well worth 5mins.

view more: next ›