Forum Discussion

jackypatel's avatar
jackypatel
Icon for Helper I rankHelper I
2 years ago
Solved

Unique date wise unique Product Count

Hi...... My Database name is "PDI DATA"&  i required Unique date wise unique names count. E.g. 27-03-2021 has "HM-12.5A-LM-ACC-NS" count is 1 & 27-03-2021 has "12.5C-FDB-ACC" also count is 1. And at ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    PowerPivot is crashing on my system so i cannot frame this solution in MS Excel.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Based on the data that you have shared, show the expected result clearly.

jackypatel's avatar
jackypatel
Icon for Helper I rankHelper I
2 years ago

if calculate with Date than out put is OK, But when convert into this goes wrong.

 

I need output as per below

MonthProductCount
March-23HM-12.5A-LM-ACC-NS1
 12.5C-FDB-ACC1
 LTT8-201
 CLR400000-A21
 LD200686-E21
 LDRR24-CDL1
 LL725003-D11
 LDLRC-20PRO-CDL1
 LT8-20-865-21
 Total Count9

 

    • jackypatel's avatar
      jackypatel
      Icon for Helper I rankHelper I
      2 years ago

      Thanx for the file... but i am not using Power BI. so i cant open it. Plz send me .xlsx format file or .pdf format file.

       

      Plz

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        2 years ago

        This is a PBI forum.  Before you post your question, shouldn't you ensure that you already have the software?