Forum Discussion

chiru5262's avatar
chiru5262
Helper III
6 years ago

Display data till current month

I've finance data available for total financial year July 2019 to June 2020.

 

But for now I want to display the data till current month, e.g. till April 2020 in a Line chart.

 

What dax formula to use.

 

Appreciate your help.

 

Cheers,

Chiru

Dax commands help

1 Reply

  • nandukrishnavs's avatar
    nandukrishnavs
    Community Champion
    6 years ago

    chiru5262 , you can write a calculated column based on the date field. 

     

    Example

     

     

     

    if(Today()>=Table[Period],"Year-to-Date")

     

     

     

    Then apply this column as visual-level/page-level/report-level filter and select value as "Year-to-Date"

    Did I answer your question? Mark my post as a solution!
    Appreciate with a kudos     🙂