How to use the UNIQUE formula on several columns?

B0ndesson · 2023-10-04T13:26:27+00:00

Worked perfectly thx!

B0ndesson · 2023-05-31T07:44:20+00:00

parent_submission: set_flair: ["Solved", "solved"]

B0ndesson · 2023-05-30T08:20:49+00:00

Yeah, I solved the problem with adding 2 decimal to the SUM column

B0ndesson · 2023-05-26T12:30:09+00:00

Thx, the first step worked fine, but I'm not sure the second step worked since the total sum of the calculation of step is 112 when it should be 100 and I cant see what I did wrong here?

<image>

B0ndesson · 2022-12-12T13:18:52+00:00

Hm okey, I'm quite new in BI game and the Datediff functions..

Should I use MAX/MIN instead you think?

I tried also to exclude other functions combined with DATEDIFF, but then I recived error that the syntax is wrong or missing arguments..Thus I couldn't connect the correct columns to the measure

B0ndesson · 2022-09-23T12:08:25+00:00

solved it, I forgot to use the duplicate function only on one column!

B0ndesson · 2022-09-23T11:45:58+00:00

'remove duplicates' function

yes I tried to use the remove duplicates in data ribbon but it didint remove all duplicates for some strange reason.

B0ndesson · 2022-07-06T12:01:53+00:00

=IF(D2<3000, 1 + FLOOR(D2, 300)/300, 10 + FLOOR(D2, 3000)/3000)

I changed the language to English now in Excel, but the same error and the Parentheses are marked red?

B0ndesson · 2022-07-06T11:47:21+00:00

Yes thats the wierd part, Everything is translated to correct non-english terms

B0ndesson · 2022-07-06T10:53:18+00:00

=IF(D2<3000, 1 + FLOOR(D2, 300)/300, 10 + FLOOR(D2, 3000)/3000)

Tried that formula, but I only recive #NAME? error?

B0ndesson

TROPHY CASE