Case 968 How to make sales and target amount for same month appear at same row ?

[Paulyeo11]

Hi All

My Target Table :-

Pls notice that the target only one row , and the date alway start 1st of the month.

My sales Table :-

My Result Now :-

My expected result :-

My Raw data and PBI file :-

https://www.dropbox.com/sh/21b67fxn4nijq39/AABehihfheuoEFfZdIWVFQVba?dl=0

Paul Yeo

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[Paulyeo11]

Hi Ash 

thank you for sharing , but my requirement is to make the sales and target amount for each month appear at single row.

Paul

[Ashish_Mathur · Accepted solution]

Hi,

The only way to do that is to replace Date with Month names.  In the Calendar Table, write a calculated column formula to extract Month name and drag that inside the visual.  Drag Date out of the visual.

[amitchandak]

@Paulyeo11 , In place of date you can use month-year or month start date or end date and combine

In your date table have columns

Month year = format([Date], "MMM YYYY")

Month year sort= format([Date], "YYYYMM") //sort month year on this

Month End date = eomonth([Date],0)

Month start date = eomonth([Date],-1)+1