show start month revenue delta 0

[Anonymous]

Current Result

Expected Result 

Hi All, 

I  wanted to show starting 0 value for month June 2020 (which first month of Revenue). Any help will be highly valuable. 

Thanks

[amitchandak]

@Anonymous , Try like

Assumption is not that we have date table 

measure
var _min = minx(filter(Table, not( isblank(Table[sales]) || Table[sales =0)),Table[date])
return
if(eomonth(max(Date[date]),0) <= eomonth(_min,0) , blank(), [measure])

or 

measure
var _min = minx(filter(Table, not( isblank(Table[sales]) || Table[sales =0)),Table[date])
return
if(eomonth(max(Table[date]),0) <= eomonth(_min,0) , blank(), [measure])

[Anonymous]

Thanks Amit. I have a full date table.

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.