Display data till current month

chiru5262 — Mon, 27 Apr 2020 10:51:08 GMT

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

Re: Display data till current month

nandukrishnavs — Mon, 27 Apr 2020 11:31:28 GMT

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 🙂

topic Display data till current month in DAX Commands and Tips

Display data till current month

Re: Display data till current month