Forum Discussion
Max ID in table
Hi, I have a Dim_Period and I'm trying to retrieve the max Week ID for the table in Power BI. How should I get the max ID and not getting filtered by Week column?
The value in Week column will change in Power BI depending on which Fiscal Quarter I select.
Regards,
BK
Anonymous , New measure without filter
maxx(all(Table), Table[Week])
with filter
maxx(allselected(Table), Table[Week])
New column, it will not take slicer value
maxx(Table, Table[Week])
1 Reply
Anonymous , New measure without filter
maxx(all(Table), Table[Week])
with filter
maxx(allselected(Table), Table[Week])
New column, it will not take slicer value
maxx(Table, Table[Week])