Forum Discussion
Measure to extract month
Hello Community, I am connected to a live dataset where I can't create calculated columns or go to the power query, I have a column date and I want to extract the month/Year from it. Is there a...
Sorry v-yanjiang-msft , but the measure didn't work because it's direct query 😞
v-yanjiang-msft
Community Support
Community SupportHi Anonymous ,
I modify the formula based on your sample data, you can have a try.
SUM =
SUMX (
FILTER (
ALL ( 'Table' ),
YEAR ( 'Table'[Date] ) = YEAR ( MAX ( 'Table'[Date] ) )
&& MONTH ( 'Table'[Date] ) = MONTH ( MAX ( 'Table'[Date] ) )
&& 'Table'[Number] = MAX ( 'Table'[Number] )
),
'Table'[Value]
)
Get the result.
I attach the sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.