YTD vs Previous YTD

[MAC0971]

I have a model setup that dislplays YTD sales and percent change from previous YTD sales by month. It works great except instead of only showing data for YTD (i.e. January and February) It is showing data for the entire 12 month period with blanks for current year sales and -100% for change from previous year. How do I get the report to stop showing data when current year sales are blank?

[datafi3nd · Accepted solution]

A quick solution could be to add date filter on the visual, and choose something like "10 years before" and tick "include today". This will prevent the chart going to the future.

[Greg_Deckler]

@MAC0971 You could add an if statement that if current year is blank, just return blank. Hard to say exactly. These may help:

Better Year to Date Total - Microsoft Power BI Community

Better Year Over Year Change - Microsoft Power BI Community

You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...