Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
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
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
DATEADD(xxx,-7,DAYS)
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.
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-...
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/1447...
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.
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-...
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/1447...
User | Count |
---|---|
68 | |
47 | |
21 | |
19 | |
15 |
User | Count |
---|---|
123 | |
42 | |
39 | |
26 | |
24 |