Forum Discussion

gantaran's avatar
gantaran
Regular Visitor
1 year ago
Solved

Month-to-Date Daily Bar Chart

I'd like to show the MTD daily sales in a bar chart.  For example, if I select the date Sept 15, 2024, the visual will show the daily sales from Sept 1 to 15.  How do I do that?
  • lbendlin's avatar
    lbendlin
    1 year ago

     

    Net Gen YTD = 
var d = max('Calendar'[Date])
var fd = max('Table'[Date])
return if(format(fd,"mmdd")<=format(d,"mmdd") && year(fd)=year(d),SUM('Table'[Net Generation]))

     

lbendlin's avatar
lbendlin
Super User
1 year ago

 

Net Gen YTD = 
var d = max('Calendar'[Date])
var fd = max('Table'[Date])
return if(format(fd,"mmdd")<=format(d,"mmdd") && year(fd)=year(d),SUM('Table'[Net Generation]))

 

gantaran's avatar
gantaran
Regular Visitor
1 year ago

Thanks again!