Hi, Hoping someone has a magic bullet to help me with a DAX formula.
I've created a report for a client that has a table that shows budget, forecast, and actuals both by month (columns) and cumulative (lines). The table is built from DAX measures I've created in the data model. It works great, with one exception---the cumulative actuals (the red line). I want the line to stop at the current date. There are no actual yet for future months, and the flat, red line just pisses me off.
financials chart.JPG
Here is a screen shot of the table and associated measures in the data model:
ftable.JPG
And here is the formula I used to create the "cumulative" measure. It is based on calendar date/year. I have fussed around with it, thinking maybe I could figure out how to have it measure calenader date/month - doesn't work. Or maybe calendar date/today - doesn't work. I know there has to be a way, but I haven't figured it out yet. The report is due Monday....anyone have any ideas??
dax *** measure.JPG
Thanks for any thoughts/suggestions!
Bookmarks