Forum Discussion
Helper IIActive customers count
If you have a date table linked to the fact table you can try
Active Customers = VAR SummaryTable = ADDCOLUMNS ( SUMMARIZE ( Sales, Sales[Customer] ), "@num months", COUNTROWS ( CALCULATETABLE ( SUMMARIZE ( Sales, 'Date'[Year month] ) ) ) ) RETURN COUNTROWS ( FILTER ( SummaryTable, [@num months] >= 3 ) )- calculation done
Active dealer in ficial year = CALCULATE([Active Customers],DATESYTD(Calendar_new[Date],"03/31"))
Super UserIf you have a date table linked to the fact table you can try
Active Customers =
VAR SummaryTable =
ADDCOLUMNS (
SUMMARIZE ( Sales, Sales[Customer] ),
"@num months", COUNTROWS ( CALCULATETABLE ( SUMMARIZE ( Sales, 'Date'[Year month] ) ) )
)
RETURN
COUNTROWS ( FILTER ( SummaryTable, [@num months] >= 3 ) )
SachinNamdeo-20"Thank you for your valuable suggestion but it gives me blank value, Please suggest me any other measure i also mention my pbi file above"
- johnt75
Your date table isn't linked to the invoice table. You need to link it on the appropriate field.
- SachinNamdeo-20
"Sorry for mistake sir in this file date is linked with cube invoice but it also return blank value"
https://drive.google.com/file/d/1QPMBDmnmupMDBqSofXjaLCB6OpV3TAKo/view?usp=sharing
- SachinNamdeo-20
Sir IF we want the same calculation on ficial year how would we can, please suggest
DATESYTD(Calendar_new[Date],"03/31") - SachinNamdeo-20
"Sir IF we want the same calculation of your given measure on ficial year how would we can, please suggest".
DATESYTD(Calendar_new[Date],"03/31")- SachinNamdeo-20calculation done
Active dealer in ficial year = CALCULATE([Active Customers],DATESYTD(Calendar_new[Date],"03/31"))
- SachinNamdeo-20
Thank you sir for your valuable suggestion