Days Difference between two dates in same column with duplicate dates in Power BI

[erp]

I have a column with duplicate dates. I need to calculate date difference based on another column.

For example, I have Stage column with 1,2,3... repeated values . What will be function I can use to calculate date values differences for stage 1?

Thanks in Advance..

[ryan_mayu · Accepted solution]

@erp 

maybe you can try this

measure=calculate(max(lastdate),allexcept(table,bomno))-calculate(min(lastdate),allexcept(table,bomno))

[erp]

Thanks for your answers...

[Jihwan_Kim]

Days Diff Measure : =
VAR ranking =
RANKX (
FILTER ( ALL ( 'Table' ), 'Table'[Stage] = MAX ( 'Table'[Stage] ) ),
CALCULATE ( MAX ( 'Table'[Date] ) ),
,
ASC
)
VAR result =
DATEDIFF (
CALCULATE (
MAX ( 'Table'[Date] ),
FILTER (
ALL ( 'Table' ),
'Table'[Stage] = MAX ( 'Table'[Stage] )
&& RANKX (
FILTER ( ALL ( 'Table' ), 'Table'[Stage] = MAX ( 'Table'[Stage] ) ),
CALCULATE ( MAX ( 'Table'[Date] ) ),
,
ASC
) = ranking - 1
)
),
MAX ( 'Table'[Date] ),
DAY
)
RETURN
result

https://www.dropbox.com/s/rwbkhoz3ir6d789/erp.pbix?dl=0 

[ryan_mayu]

@erp 

pls provide some sample data and expected output.

[erp]

My sample data

So, I need days difference between first date and last date (in lastdate Column) based on bomno column. 

Thanks in advance..

[ryan_mayu · Accepted solution]

@erp 

maybe you can try this

measure=calculate(max(lastdate),allexcept(table,bomno))-calculate(min(lastdate),allexcept(table,bomno))

[YRK]

Need DAX(Power BI) for no of days for Each SGNo from the Above Table.

[ryan_mayu]

what's the expected output? it's better to create a new postand provide the detailed info.

[erp · Accepted solution]

Thanks a lot. It worked for me...😊

[ryan_mayu]

you are welcome