Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Doubts about time intelligence

tengo la siguiente información actualizada a hoy, agosto 2022     Quiero configurar a través de la fecha (date) que muestre la información a mes vencido, esto es que muestre informacion de 2...
Need Help
Tips and Tricks
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    Hi Anonymous ,

    Pls test create the below measure ,then apply it as filter:

    FILTER =
VAR today1 =
    DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ) - 1
VAR lastyear =
    DATE ( YEAR ( today1 ) - 1, 1, 1 )
RETURN
    IF (
        MAX ( 'Table'[Date] ) >= lastyear
            && MAX ( 'Table'[Date] ) <= today1,
        1,
        0
    )

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    Best Regards,
    Lucien

v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi Anonymous ,

Pls test create the below measure ,then apply it as filter:

FILTER =
VAR today1 =
    DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ) - 1
VAR lastyear =
    DATE ( YEAR ( today1 ) - 1, 1, 1 )
RETURN
    IF (
        MAX ( 'Table'[Date] ) >= lastyear
            && MAX ( 'Table'[Date] ) <= today1,
        1,
        0
    )

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Lucien