topic Re: Datos anteriores a una fecha in DAX Commands and Tips

Datos anteriores a una fecha

Chris03_ — Wed, 13 Mar 2024 12:35:36 GMT

Buenas... necesito saber como hacer para al elegir un intervalo de fechas (por ejemplo de una semana especifica) en el segmentador, en una tabla/matriz me salgan los valores de 1 semana antes al intervalo de fechas elegida en el segmentador. Desde ya muchas gracias, si pueden ayudarme por favor.

Re: Datos anteriores a una fecha

lbendlin — Wed, 13 Mar 2024 21:19:54 GMT

DATEADD(xxx,-7,DAYS)

Re: Datos anteriores a una fecha

Chris03_ — Thu, 14 Mar 2024 11:56:12 GMT

Lo intente, pero no da el resultado deseado. Busco hacer una medida, que al poner en una matriz y utilice un segmentador de fecha para elejir un intervalo de fechas (una semana) en la matriz se reflejen valores pero de 7 dias antes.

Re: Datos anteriores a una fecha

lbendlin — Thu, 14 Mar 2024 12:50:10 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Datos anteriores a una fecha

Chris03_ — Fri, 15 Mar 2024 16:17:19 GMT

En la foto se observa los datos obtenidos al filtrar entre las fechas 17/02 y 23/02. Lo que necesito es que al realizar ese filtro, es que esa medida Peso 1 Med me de el valor pero de lo obtenido 1 semana antes es decir, del 10 al 16. El datediff no me sirvio.

Re: Datos anteriores a una fecha

lbendlin — Fri, 15 Mar 2024 16:20:30 GMT

Second request: Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Datos anteriores a una fecha

Anonymous — Fri, 22 Mar 2024 08:28:49 GMT

Hi Chris03_ ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create a new date table

Date = VALUES('Table'[Date])

Use the Date[Date] as the value of slicer

Create measures

MaxDate = IF( SELECTEDVALUE('Table'[Date]) <= MAX('Date'[Date]) - 7, 1, 0 )

MinDate = IF( SELECTEDVALUE('Table'[Date]) >= MIN('Date'[Date]) -7, 1, 0 )

Use Table[Date] as table value and Apply measure to filter

Final output

If you want to change the date interval dynamically, i.e., instead of a week, you can create another measure to replace the fixed 7

DateRange = DATEDIFF(MIN('Date'[Date]),MAX('Date'[Date]),DAY)+1

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly