bhmiller89 Tracker

Ranking a field based on a measure

bhmiller89 — Thu, 11 Nov 2021 01:18:06 GMT

I have a dataset where each record is a sale. One of the fields is "sales rep" and I have a measure written called "MTD Production$"

I need to rank each Sales Rep by the value of the measure "MTD PRoduction$" So far I can't get anything to work. Any help is appreciated

Average for data

bhmiller89 — Thu, 27 May 2021 11:11:10 GMT

I have columns: Date | Card Reads | City

I need to calculate the average card reads by city and compare it to a specific address. So basically when I slect an address within that city, I want the SUM(Card Reads) to populate against that city's average.

Help with simple measure

bhmiller89 — Thu, 27 May 2021 10:59:10 GMT

I have data that shows Card Reads. I need to calculate the following and be able to use "State" as the legend

% = ([Unique card reads] / [Unique card reads in Jan. 2020]) * 100%

Basically divide every month's card reads by that value in Jan 2020, broken down by State. I tried hardcoding it and it still doesn't work but I"d like to not have it hard coded and have it in a measure.

Make End of Month Value equal beginning of next month's value

bhmiller89 — Thu, 15 Apr 2021 17:31:51 GMT

I have two measures: starting and ending. I need the Ending value of January to equal the starting value of February, and so on. Is there a way to write this?

Top 10%

bhmiller89 — Tue, 11 Aug 2020 11:23:38 GMT

Sé cómo usar el filtro Top N, pero la pregunta es por el 10% superior de los valores. Tenemos un gran conjunto de datos de tickets, cada ticket tiene un valor de "duración". Queremos ver el 10% de esos valores en una tabla

Cualquier ayuda sobre cómo filtrar que se aprecia

Top 10%

bhmiller89 — Tue, 11 Aug 2020 11:22:34 GMT

I know how to use the Top N filter, but the ask is for the top 10% of values. We have a large dataset of tickets, each ticket has a "duration" value. We want to see the 10% of those values in a table

Any help on how to filter that is appreciated

Fecha más dos meses

bhmiller89 — Mon, 03 Aug 2020 18:42:52 GMT

Tengo datos con una "fecha de ir en vivo". Quiero mostrar el Amount$ para cualquier cosa con una fecha en vivo Go de 2 o más meses de distancia. Por ejemplo, es agosto de 2020 quiero mostrar cualquier cosa con una fecha de inicio en vivo de octubre de 2020 en adelante.

Calculate(Sum(Amount$), GoLiveDate > ?

¿Cómo escribiría esto en una medida?

Date plus two months

bhmiller89 — Mon, 03 Aug 2020 18:41:48 GMT

I have data with a "go live date." I want to show the Amount$ for anything with a Go live date of 2 or more months away. Example, it is August 2020 I want to show anything with a go live date of October 2020 onward.

Calculate(Sum(Amount$), GoLiveDate >= ......?

How would I write this into a measure?

Problemas de formato condicional

bhmiller89 — Tue, 02 Jun 2020 12:54:55 GMT

Tengo una matriz que utiliza muchos puntos de datos diferentes, todos $dollars o perents.

Necesito mostrar cualquier cosa negativa (<0) como el color de fuente rojo.

Cuando intento el formato condicional, solo se me presenta la opción de "si el valor es mayor o igual que", "si el valor es mayor que" "si el valor está en blanco" y luego siempre me hace elegir una segunda condición.

Literalmente sólo necesito decir "si <0, rojo, más negro"

Conditional Formatting Issues

bhmiller89 — Tue, 02 Jun 2020 12:53:51 GMT

I have a matrix that uses many different data points, all $dollars or perents.

I need to show anything negative (<0) as the Font Color Red.

When I attempt conditional formatting, I am only presented with the option of "if value is greater than or equal to", "if value is greater than" "if value is blank" and then it always makes me pick a second condition.

I literally just need to say "if <0, red, else black"

Agregar una fecha estática como una columna personalizada

bhmiller89 — Thu, 30 Apr 2020 14:18:16 GMT

Tengo diferentes tablas de datos que representan datos para diferentes combos YearMonth. Necesito agregar una columna a cada tabla con el YearMonth apropiado. Por ejemplo, quiero una columna donde cada registro diga "1/1/2019"

¿Cómo escribiría esto en el cuadro "Agregar columna personalizada"?

Adding a static date as a custom column

bhmiller89 — Thu, 30 Apr 2020 14:15:44 GMT

I have different data tables that represent data for different YearMonth combos. I need to add a column to each table with the appropriate YearMonth. For example, I want a column where each record says "1/1/2019"

How would you type this in the "Add Custom Column" box?

Adición de una fecha estática como columna personalizada

bhmiller89 — Thu, 30 Apr 2020 14:07:00 GMT

¿Cómo escribiría esto en el cuadro "Agregar columna personalizada"?

Adding a Static Date as a Custom Column

bhmiller89 — Thu, 30 Apr 2020 13:58:35 GMT

I have different data tables representing data for different YearMonth combos. I need to add a column to each table with the appropriate YearMonth. For example, I want a column where every record says "1/1/2019"

How would I write this in the "Add Custom Column" box ?

¿Es posible ejecutar 32 bits y 64 bits simultáneamente?

bhmiller89 — Tue, 28 Apr 2020 18:27:09 GMT

¿Es posible descargar ambas versiones en mi máquina de 64 bits? Hasta ahora mi archivo de 32 bits se bloquea

Is it possible to run 32 bit and 64 bit simultaneously?

bhmiller89 — Tue, 28 Apr 2020 18:26:58 GMT

Is it possible to have both versions downloaded on my 64-bit machine? So far my 32 bit file crashes

Re: Problema de dependencia circular

bhmiller89 — Thu, 09 Apr 2020 20:12:21 GMT

@Greg_Deckler No existe una relación directa entre el Cuadro1 y el Cuadro2, así que cuando estaba calculando el "Comercio Total" en el Cuadro1 utilicé:

Comercio total: Tabla1[VALUE1]+Tabla1[VALUE2]+ LOOKUPVALUE('Table3'[ Rate], 'Table3'[Key], Table1[Key])

Ahora estoy tratando de calcular

Beneficio bruto- Tabla1[Valor5]-Tabla1[Comercio total]- RELACIONADO('Tabla4'[Valor8])

ahí es donde obtengo el error. Porque estoy tratando de usar el Comercio Total en una columna calculada y El Comercio Total ya está usando LOOKUPVALue.

¿Eso ayuda?

Re: Circular Dependency Issue

bhmiller89 — Thu, 09 Apr 2020 20:12:11 GMT

Greg_Deckler There is not a direct relationship between Table1 and Table2 so when I was calculating "Total Trade" in Table1 I used:

Total Trade = Table1[VALUE1]+Table1[VALUE2]+ LOOKUPVALUE('Table3'[ Rate], 'Table3'[Key], Table1[Key])

Now I am trying to calculate

Gross Profit = Table1[Value5]-Table1[Total Trade]- RELATED('Table4'[Value8])

that's where I get the error. Because I'm trying to use Total Trade in a calculated column and Total Trade is already using LOOKUPVALue.

Does that help?

Problema de dependencia circular

bhmiller89 — Thu, 09 Apr 2020 20:03:56 GMT

Tengo un conjunto de datos con muchas tablas. Usé LOOKUPVALUE en una columna calculada para obtener la columna "Comercio total" en la Tabla1

Necesito calcular otra columna calculada llamada "Gross Profit" que use "Total Trade" en la fórmula. sin embargo, obtengo "se detectó una dependencia circular: Tabla1[Comercio total], Tabla1[Beneficio bruto], Tabla1[Comercio total]

Tiene que ser una columna y no una medida

Cualquier ayuda es apreciada

Circular Dependency Issue

bhmiller89 — Thu, 09 Apr 2020 20:03:46 GMT

I have a dataset with many tables. I used LOOKUPVALUE in a calculated column to get the column "Total Trade" into Table1

I need to calculate another calculated column called "Gross Profit" that uses "Total Trade" in the formula. however, I get "a circular dependency was detected: Table1[Total Trade], Table1[Gross Profit], Table1[Total Trade]

It needs to be a column and not a measure

Any help is appreciated