Forum Discussion
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 ...
PowerPivot is crashing on my system so i cannot frame this solution in MS Excel.
if calculate with Date than out put is OK, But when convert into this goes wrong.
I need output as per below
| Month | Product | Count |
| March-23 | HM-12.5A-LM-ACC-NS | 1 |
| 12.5C-FDB-ACC | 1 | |
| LTT8-20 | 1 | |
| CLR400000-A2 | 1 | |
| LD200686-E2 | 1 | |
| LDRR24-CDL | 1 | |
| LL725003-D1 | 1 | |
| LDLRC-20PRO-CDL | 1 | |
| LT8-20-865-2 | 1 | |
| Total Count | 9 |
Hi,
PBI file attached.
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
This is a PBI forum. Before you post your question, shouldn't you ensure that you already have the software?
Sir,
I am using Power Pivot in Excel. Power BI Software is not available.
Kindly plz share the .xlsx file