如何计算 Yeserday、过去 7 天、本周到一天、本月到一天的用户在 Power bi 中记录的计数?

Question

我正在尝试计算系统上登录的用户计数。

在我的桌子里，我有

Id，TRANSDATE 现在我想计算四个类别的度量

这是昨天，过去7天，本周到一天，这个月到一天计数。

Yesterday = 
CONCATENATE(
CONCATENATE(
"Yesterday Count",
UNICHAR(10)
), " (" & 
FORMAT(TODAY - 1, "DD-MMM") 
& ")"
)
Last 7  Days =  
CONCATENATEN(
CONCATENATE(
"Last 7 Days  Count",UNICHAR(10)
), 
" (" &  
FORMAT(TODAY() - 7,"DD-MMM") 
& " to " & 
FORMAT(TODAY() - 1,"DD-MMM") &")" 
)

This Week till date = 
CONCATENATE(
CONCATENATE(
“This Week till date Count”,
UNICHAR(16)
), SWITCH(
TRUE(),
FORMAT(
if (
WEEKDAY(TODAY(),1) == 1, 
TODAY(),
TODAY() - (WEEKDAY(TODAY(),1) - 1))
,"DD-MMM") == 
FORMAT(TODAY(),"DD-MMM"), " ("& 
FORMAT{TODAY() ,"DD-MMM") &“)", 
FORMAT(
if (
WEEKDAY(TODAY(),1) == 1, 
TODAY(),
TODAY() - (WEEKDAY(TODAY(),1) - 1)
),"DD-MMM") <> 
FORMAT(TODAY(),"DD-MMM")," ("&
FORMAT(
if(
WEEKDAY(TODAY(),1) == 1, 
TODAY(),
TODAY() - (WEEKDAY{TODAY(),1) - 1)
),"DD-MMN") &" to “& 
FORMAT(TODAY(), "DD-MMM") &")"
)
This Month till date = 
CONCATENATE(
CONCATENATE(
"This Month till date Count”,
UNICHAR(10)
), SWITCH(
TRUE() ,
FORMAT(DATE(
YEAR(TODAY()),
MONTH(TODAY()),
1),
"DD-MMM"
) == 
FORMAT(
TODAY(),
"DD-MMM"
), “ ("& 
FORMAT(
TODAY(),
"DD-MMM"
) &")", 
FORMAT(
DATE(
YEAR(TODAY()),
MONTH(TODAY())
,1
),
"DD-MMM") <> 
FORMAT(
TODAY(),
"DD-MMM"
)," ("& 
FORMAT(
DATE(
YEAR(TODAY()),
MONTH(TODAY()),
1),
"DD-MMM") &" to “& 
FORMAT(
TODAY() , 
"DD-MMM" &") "
)

Answer 1

我通过以下方式解决了

这个问题

YesterdayM = 
CALCULATE(
DISTINCTCOUNT('user’[Id]),
FILTER('user’, [TRANSDATE] = TODAY() - 1)
) + 0

LastSevenDaysM = 
CALCULATE(
DISTINCTCOUNT(‘user’[Id]),
FILTER(‘user‘,[TRANSDATE] >= (TODAY() - 7) && [TRANSDATE] < TODAY())
) + 0 

CurrentWeekTillDateM = 
CALCULATE(
DISTINCTCOUNT( 'user’ [Id]),
FILTER(’user',[TRANSDATE] >= 
if(
WEEKDAY(TODAY(),1) == 1, 
TODAY(),
TODAY() - (WEEKDAY(TODAY(),1) - 1)
)
)
) + 0

CurrentMonthTillDateM = 
CALCULATE(
DISTINCTCOUNT(‘user‘ [Id]),
FILTER(‘user‘, [TRANSDATE] >= 
DATE(
YEAR(TODAY()),
MONTH(TODAY())
,1)
) + 0