Display data till current month

[chiru5262]

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

[nandukrishnavs]

@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 🙂