Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi @zalalu ,
First in KPI table,create a column as below:
_Avg KPI per day =
IF (
'KPI'[Avg KPI per day] = 0,
CALCULATE (
MAX ( 'KPI'[Avg KPI per day] ),
FILTER (
'KPI',
'KPI'[Material Type] = EARLIER ( 'KPI'[Material Type] )
&& 'KPI'[Avg KPI per day] <> 0
)
),
'KPI'[Avg KPI per day]
)
Then in data table create a column as below:
KPI.Avg KPI per day =
LOOKUPVALUE (
'KPI'[_Avg KPI per day],
'KPI'[Site A], 'Data'[Site A],
'KPI'[Site B], 'Data'[Site B],
'KPI'[Material Type], 'Data'[Material Type],
BLANK ()
)
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Hi @zalalu ,
First in KPI table,create a column as below:
_Avg KPI per day =
IF (
'KPI'[Avg KPI per day] = 0,
CALCULATE (
MAX ( 'KPI'[Avg KPI per day] ),
FILTER (
'KPI',
'KPI'[Material Type] = EARLIER ( 'KPI'[Material Type] )
&& 'KPI'[Avg KPI per day] <> 0
)
),
'KPI'[Avg KPI per day]
)
Then in data table create a column as below:
KPI.Avg KPI per day =
LOOKUPVALUE (
'KPI'[_Avg KPI per day],
'KPI'[Site A], 'Data'[Site A],
'KPI'[Site B], 'Data'[Site B],
'KPI'[Material Type], 'Data'[Material Type],
BLANK ()
)
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.