Identified new entry and missing product from last month

[Amardeep100115]

Hi 

Please find the sample data where i wish to output prom the list

If there is new addition of produst id in same/last month then it should be "New" and if not then "Existing" .

Sample Excel Data 

Please guide

[v-joesh-msft]

Hi @Amardeep100115 ,

I'm a little confused by your description. A screenshot of the expected output would help tremendously.

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Amardeep100115]

Sorry For delay in replying 

Excel Data with pivot 

If you go through the excel data and pivot you will notice that there are some products which are newly added and some are stopped producing and in another month may it restarted to produce. 

i wish to know which product and it's count is newly started and stopped in perticuler month 

Unique value is the month and year

hope i am explained my query correctly

[Ashish_Mathur]

Hi,

Based on the latest file that you have shared, show the exact expected result.

[Amardeep100115]

Hi @Ashish_Mathur  

Please find the revised data for your reference, 

in this file i have revised pivot and added one more column in data, in pivot you will find the red highlighted cells where some products are stop producing and in next month it's restarted to produce ( to identify the blank cell count please refer the column total values) and in last column i have put if formula to identify the difference. 

Now i wish to see the resultd in which month which poduct is newly added and and stopped producing and it's count 

Text column or unique Should be slicer/Dropdown filter

hope i have expalained my results

Revised Excel Data 

[Ashish_Mathur · Accepted solution]

Hi,

This is what i understood.  You may download my PBI file from here.

Hope this helps.

[Amardeep100115]

Thank you @Ashish_Mathur 

a small request; is it possible to add -/+ or up(for New) and down (For churn) arrow in visulisation.

I would like to show highlights in my reports like  in below image forNew and churn products

Please guide

[Ashish_Mathur]

Hi,

So when you click on the + symbol on "New in month", you want to see those ID's which were trained in that month.  Am i correct?

[Amardeep100115]

Hello @Ashish_Mathur  Sir,

No!

If it's new in month then the KPI symbol should show "+" (Green) icon and if it's churn in that month it's should show "-"(Red) icon infront of  SQL product id.

like new addition and deletion of that month.

hope i am expalained well

Thank you 

[Ashish_Mathur]

Hi,

Someone else will help you with conditional formatting.

[Amardeep100115]

Hi @Ashish_Mathur ,

Could you help me with sumerized table of Data table in attached report like below column

Month | New  |  Closed 

Data File 

[Ashish_Mathur]

Hi,

Just select a Table visual.  Drag Year and Month to the visual.  Drag New this month and Closed this month also to the visual.  Clear all selections from the Month Name slicer.

[Amardeep100115]

I tried in that way as well but the display value is showing wrong, 

visual should show currant month data if no option is selected in slicer and if we select any month then the data should be reflact acordingly.

I am using below measure to get this 

Unique | New | Closed

On the basis of data could you please help me creating table like columns

[Ashish_Mathur]

Hi,

I tried that and it worked fine for me.  Follow the steps i have outlined and show me a screenshot of what problem you are facing.

[Amardeep100115]

When i select FY 2019 and month January then it's shows 2 and i de select the selection it shows me 129

Please suggest

[Ashish_Mathur]

Hi,

A month will have to be selected.

[Amardeep100115]

Yes
But if no month is not selected then visual should be displayed current month values

[Amardeep100115]

Hi @Ashish_Mathur 

Did you got What i want to say? if yes have you tried to get it solve?

Please help me on this 

[Ashish_Mathur]

Hi,

Hope you are doing good.  Could you kinldy start a new thread and post your question there.  Thank you for your understanding.

[Amardeep100115]

Thanks

[amitchandak]

Try something like this

new This month = if(isblank(CALCULATE(sum(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date]),-1,MONTH))),"New","Existing")

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...


https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601