Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to filter year = 2019 ?

Hi All  
Need Help
  • mpicca13's avatar
    mpicca13
    6 years ago

    Anonymous Unsure of what the use case is, if you simply want to show just 2019 data in the page you can just go to the filter pane on the right hand side, be sure to add [year] in the filter pane, select basic filtering and select checkbox for just 2019

     

    Or you could add all dates (down to date level ) to filter pane and filter by relative date.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , example measures

 

Hard coded

measure =
calculate(sum(Table[Qty]), filter(Date,year(date[date])=2019))

 

Using time intelligence

Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
Last year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Sir

May i know how to use Filter to temperay filter year =2019.

Paul