Forum Discussion

chiru5262's avatar
chiru5262
Icon for Helper III rankHelper 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 ...
Dax commands help
nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity 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 🙂