topic How to identify the difference in the table through measures in App Development

How to identify the difference in the table through measures

Rajakumaranakash — Fri, 15 Nov 2024 21:26:33 GMT

I have table with available server information with date. I want to identify the missing and added server by comparing two dates.

My Data:

Expected 2 outputs: If I select 2023-08-28 and 2023-08-14 I should get below output.

Table 1: Missing Server from old date

Table 2: Newly added Server

Report date	Added Server
8/21/2023	Server4

I could not modify my script. So I would like to do this with expression

I hope some one can help me with this

Javizh — Thu, 31 Aug 2023 10:12:04 GMT

Hello.

You can get this adding a metric to the tables, counting the servers that fullfil the condition.

For the newly added (Date is max date)

Count(distinct {<[Server] = {"= [Report date] = '$(=date(max([Report date])))'"}>} Server)

For the missing (Date is min date)

Count(distinct {<[Server] = {"= [Report date] = '$(=date(min([Report date])))'"}>} Server)

This will only work if you select only the 2 dates you want to compare.

Attached is an example.

Best regards.

Rajakumaranakash — Thu, 31 Aug 2023 11:58:15 GMT

Thank you @Javizh This worked well.