Forum Discussion

Vemul's avatar
Vemul
Icon for Helper I rankHelper I
3 years ago

Populating Column data in order table form different columns combination mix in Freight table

Good Morning all,   Hope someone can help me here, I am new to power BI and working on to calculate Transport Lead Time for Dashboard. I have two table to work with Freight Table City S...
Tips and Tricks
Vemul's avatar
Vemul
Icon for Helper I rankHelper I
3 years ago

Thanks Agin, 

getting close.

I have achieved belwo by changing code but not sure how to populate "30" days if doesn't match any combinations 

 

any suggestions Please 

Thanks

Vijay

 

 

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

Please try to write, 

 

LT Days calcualted column =
VAR  _yourresult = CALCULATE(..............................)

RETURN

IF (ISBLANK(_yourresult), 30, _yourresult)