Forum Discussion

DharmaChinta's avatar
DharmaChinta
Frequent Visitor
7 years ago
Solved

Table visual to show only current week Data By default without any filter

Hi Team,   Is there a way to show only One week Data By default without any filter on a table visual and based on the week selection change accordingly ? May be a DAX that just filter on the curren...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago
Hi DharmaChinta,

Try to create a measure like this


Measure =
CALCULATE (
SUM ( Table[Column] );
FILTER (
ALL ( Table[DateColumn] );
WEEKNUM ( Table[DateColumn] ) = WEEKNUM ( TODAY () )
)
)


Regards,
MFelix
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Is this also possible for the current week and the current year? I have multiple years.

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous 

     

    You need to add the year to the filter part of the measure:

     

    Measure =
CALCULATE (
SUM ( Table[Column] );
FILTER (
ALL ( Table[DateColumn] );
WEEKNUM ( Table[DateColumn] ) = WEEKNUM ( TODAY () )
&&
YEAR ( Table[DateColumn] ) = YEAR ( TODAY () )
)
)