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.
Hola, estoy calculando una nueva medida basada en un valor dateTime de tabla diferente usando:
Triggered = (
VAR _Cuur_start = MAX(CalculationsTable[Date])
VAR _Curr_end = MIN(CalculationsTable[Date])
return
calculate(SUM(SRTriggered[NumberOfEvents]),
FILTER(SRTriggered, SRTriggered[Date] >= _Cuur_start),
FILTER(SRTriggered, SRTriggered[Date] <= _Curr_end )))
Pero sólo funciona cuando el _Cuur_start es igual a _Cuur_end (períodode 1 día), mientras que no lo hizo en caso de días multipe.
Le agradecería que alguien pueda ayudar a 🙂
Solved! Go to Solution.
@MohannadSh1996 , Tratar como
Activado ?
VAR _Cuur_start á MAX(CalculationsTable[Date])
VAR _Curr_end á MIN(CalculationsTable[Date])
devolución
calculate(SUM(SRTriggered[NumberOfEvents]),
FILTER(all(SRTriggered), SRTriggered[Date] >- _Cuur_start && SRTriggered[Date] <-_Curr_end ))
O
Activado ?
VAR _Cuur_start á MAX(CalculationsTable[Date])
VAR _Curr_end á MIN(CalculationsTable[Date])
devolución
calculate(SUM(SRTriggered[NumberOfEvents]),
FILTER(allselected(SRTriggered), SRTriggered[Date] >- _Cuur_start && SRTriggered[Date] <-_Curr_end ))
@amitchandak, lo he probado antes, gracias por su respuesta.
@Greg_Deckler, creo que fue el problema. ¡Gracias!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |