Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!