unable to fetch the field names.

[Kumardwhbidev]

Hi Team, 

I'm very new to PBI, recently I have installed PBI desktop in my PC, I have dowloaded superstore data and connected into PBI,

here I want to find out the shipping time, so that I want to creating a new measure,

formula is : datediff(orderdate, ship date, 'day'), so I trying to write same formula in PBI, it won't fetch the fieldnames, waht is the wrong my side, please help to resolve this.

Regards

Kumar.

[GeraldGEmerick · Accepted solution]

@Kumardwhbidev Try the following:

DATEDIFF( MAX( 'SuperStoreOrders'[order_date] ) ), MAX( 'SuperStoreOrders[ship_date] ) ), "day" )

In measures, when you refer to columns you often need to specify some sort of aggregation.

[Kumardwhbidev]

Thank you So much