Field Calculations

Field calculations are explained in the following tables.

Hardware Inventory CSV
Hardware_Technopedia CSV
Software_Inventory CSV
Software_Technopedia CSV
Custom Columns

Hardware Inventory CSV

The following table explains the calculations included with the Hardware Inventory CSV.

Hardware Inventory CSV Calculations

Result

Calculation

Count HW Manufacturer

CALCULATE(DISTINCTCOUNT(Hardware_Technopedia[Manufacturer ID]))

Count HW Models

CALCULATE(DISTINCTCOUNT(Hardware_Technopedia[Model Name]))

Count HW Products

CALCULATE(DISTINCTCOUNT(Hardware_Technopedia[Product Name]))

Count Systems

CALCULATE(DISTINCTCOUNT(Hardware_Inventory[Hardware ID]))

Hardware_Technopedia CSV

The following table explains the calculations included with the Hardware_Technopedia CSV.

Hardware_Technopedia CSV Calculations

Result

Calculation

Count HW CAT

CALCULATE(DISTINCTCOUNT(Hardware_Technopedia[Category]))

Count HW SUB-CAT

CALCULATE(DISTINCTCOUNT(Hardware_Technopedia[Subcategory]))

Software_Inventory CSV

The following table explains the calculations included with the Software_Technopedia CSV.

Software_Technopedia CSV Calculations

Result

Calculation

Count SW Installs

CALCULATE(COUNT(Software_Inventory[Technopedia GUID]))

Count SW Manufacturer

CALCULATE(DISTINCTCOUNT(Software_Technopedia[Manufacturer ID]))

Count SW Products

CALCULATE(DISTINCTCOUNT(Software_Technopedia[Product ID]))

Count SW Releases

CALCULATE(DISTINCTCOUNT(Software_Technopedia[Release ID]))

Count SW Versions

CALCULATE(DISTINCTCOUNT(Software_Technopedia[Version ID]))

Software_Technopedia CSV

The following table explains the calculations included with the Software_Technopedia CSV.

Software_Technopedia CSV Calculations

Result

Calculation

Count SW CAT

CALCULATE(DISTINCTCOUNT(Software_Technopedia[Category]))

Count SW SUB-CAT

CALCULATE(DISTINCTCOUNT(Software_Technopedia[Subcategory]))

Custom Columns

If, else, and else if statements are explained in tables for the following custom columns.

Hardware Support Custom Column
Hardware End of Sale Custom Column
Software Support Custom Column

Hardware Support Custom Column

The following table explains the if, else, and else if statements for the Hardware Support custom column.

Hardware Support Custom Column Statements

Condition

Result

if [General Availability Date] = null and [General Availability Exception] = "" and [Last Availability Date] = null and [Last Availability Exception] = "" and [Obsolete Date] = null and [Obsolete Date Exception] = ""

then "No Technopedia Research"

else if [Obsolete Date] = null

then [Obsolete Date Exception]

else if [Obsolete Date] >= Date.From(DateTime.LocalNow())

then "Supported"

else if [Obsolete Date] < Date.From(DateTime.LocalNow())

then "Obsolete"

else

"No Rule"

Hardware End of Sale Custom Column

The following table explains the if, else, and else if statements for the Hardware End of Sale custom column.

Hardware End of Sale Custom Column Statements

Condition

Result

if [General Availability Date] = null and [General Availability Exception] = "" and [Obsolete Date] = null and [Obsolete Date Exception] = ""

then "No Technopedia Research"

else if [Last Availability Date] = null

then [Last Availability Exception]

else if [Last Availability Date] >= Date.From(DateTime.LocalNow())

then "On Sale"

else if [Last Availability Date] < Date.From(DateTime.LocalNow())

then "End of Sale"

else

"No Rule"

The following table explains the if, else, and else if statements for the Hardware End of Sale custom column when using the option “no populated last availability exception”.

Hardware End of Sale Custom Column Statements for the option “no populated last availability exception”

Condition

Result

if [General Availability Date] = null and [General Availability Exception] = "" and [Obsolete Date] = null and [Obsolete Date Exception] = ""

then "No research"

else if [Last Availability Date] = null and [Last Availability Exception] = ""

then [Obsolete Date Exception]

else if [Last Availability Date] = null

then [Last Availability Exception]

else if [Last Availability Date] >= Date.From(DateTime.LocalNow())

then "On Sale"

else if [Last Availability Date] < Date.From(DateTime.LocalNow())

then "End of Sale"

else

"No Rule"

Software Support Custom Column

The following table explains the if, else, and else if statements for the Software Support custom column.

Software Support Custom Column Statements

Condition

Result

if [General Availability Date] = null and [General Availability Exception] = "" and [End of Life Date] = null and [End of Life Exception] = ""

then "No Research"

else if [General Availability Date] = null

then [General Availability Date Exception]

else if [End of Life Date] = null

then [End of Life Exception]

else if [End of Life Date] >= DateTime.From(DateTime.LocalNow())

then "Standard Support"

else if [End of Life Date] < DateTime.From(DateTime.LocalNow()) and [Obsolete Date] >= DateTime.From(DateTime.LocalNow())

then "Extended Support"

else if [Obsolete Date] < DateTime.From(DateTime.LocalNow())

then "Obsolete"

else

"No Rule"