End of month sales on secondary y-axis

[artblakey]

Hi,

I have a bar chart showing month total sales for the year, but I would like to add a secondary y-axis on this same visual of a line chart showing only the sales volume for the last day of each month.  With my limited PowerBI knowledge, I imagine that I would create a new column in my Dates table using DAX to label each row, but I have no idea how to do this.  Could somebody please help me with this?

Thanks in advance.

[amitchandak · Accepted solution]

@artblakey , Create a measure like this and try

calculate([meausre],filter(date,date[date]=lastdate(date[date])))

or
calculate([meausre],filter(date,date[date]=max(date[date])))

or
calculate([meausre],filter(date,date[date]=endofmonth(date[date])))

[artblakey]

Hi @amitchandak 

Thanks, but just to clarify, I only have to use one of your three suggested measures?

Also, what do I put in place of [measure]?  Do I have to create another measure to place here?

I have limited knowledge of DAX so appreciate your clarification.

Thanks.

[v-lili6-msft]

hi @artblakey 

You could use use one of the three suggested measures, the logic is same for them.

If you still have the problem, please share your sample pbix file for us have a test, that will be a great help.

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Lin

[artblakey]

Hi @v-lili6-msft 

Thanks for your response, I will give those a try.

But I don't understand what I put in place of "[measure]", in those measures suggested?  Do I have to create another measure to place here?

Thanks.

[TomMartens]

Hey @artblakey ,

you don't have to create a measure, you can replace

[measure]

by using this DAX expression

CALCULATE(SUM('tablename'[salescolumn]))

Regards,

Tom