webstark Tracker

Re: Counting number of rows where number equals something

webstark — Mon, 16 Oct 2017 08:46:40 GMT

Sorry, it looks like it's just comparing the integer values.

When I put in = 1, I get Blank(), but >= 2 equals everything in the table.

40044114083914688 is greater than 2..everything matches

40044114083914688 = 1, blank().

Counting number of rows where number equals something

webstark — Mon, 16 Oct 2017 07:53:16 GMT

Hi team,

Very simple one here.

I have the table below. I have a Site ID, a Pallet ID and a count of the

number of boxes on pallet (this is a count selection on the dropdown). A pallet can 1 or more boxes on it.

The number of boxes will either be 1 or >= 2.

I just want another 2 measures where the count of all the 1's = something and >=2 = something else. How many times does the one appear and how many times is it 2 or more?

I can do it in T-SQL but I just can't get a Filter working properly.

Help!

Count of changes between two dates

webstark — Wed, 05 Jul 2017 04:54:12 GMT

Hi,

Just say I have this table in BI.

Location Rack 1 (quant) Rack 2 Rack 3 Date

S1 12 12 33 1/4/17

S1 13 20 8 1/5/17

S3.....

I want to calculate the differences in the Rack columns between the last two dates and display it in the same record as the last date.

So, I would have new column/measure that would say Rack 1 change = 1, Rack 2 change = 8, Rack 3 change = -25

Is this even possible??

Getting latest date from date column where there are multiples of a value in another column

webstark — Wed, 01 Feb 2017 04:10:38 GMT

Hi,

I have a table with two columns; a SiteID column (number) where there could be mutiple rows for each site ID and a DateAdded field which would have the date the equipment was added to the site.

I want to create a another column which compares the dates for mulitple entries of the same SiteID and returns the latest date of how ever many there are

SiteID Date Added Last Date

--------|-------------------------|--------------

1 | 1/1/2016 00:00:00

1 | 15/5/2016 00:00:00

1 | 2/11/2016 00:00:00

1 | | 2/11/2016 00:00:00

Can this be done?