Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I m using below measures to calculate Total count between 320 and 365 days.Its showing blank value..Is this measure is correct ?
Date'[Date] is calendar table join with Table [CREATED_ON]) .
Age= CALCULATE(COUNT(Table [CREATED_ON]),DATESBETWEEN(Table[CREATED_ON],LASTDATE(DATEADD('Date'[Date],-320,DAY)),LASTDATE(DATEADD('Date'[Date],-365,DAY)) ) )
Thanks
Solved! Go to Solution.
Its working . For older than 1 year .
it should be below measure right?
Age=
var _dt =minx('Date','Date'[Date])
var _min =_dt+365
return
CALCULATE(COUNT(Table [CREATED_ON]),Table [CREATED_ON]>=_min)
@Anonymous , try like
Age=
var _dt =minx('Date','Date'[Date])
var _min =_dt-365
var _max = _dt -320
return
CALCULATE(COUNT(Table [CREATED_ON]),Table [CREATED_ON]>=_min,Table [CREATED_ON]<=_max)
Its working . For older than 1 year .
it should be below measure right?
Age=
var _dt =minx('Date','Date'[Date])
var _min =_dt+365
return
CALCULATE(COUNT(Table [CREATED_ON]),Table [CREATED_ON]>=_min)
Hi @Anonymous ,
It's the same principle if the previous measure worked.
Glad to hear the issue is solved. You can accept your reply as solution, that way, other community members could easily find the answer when they get same issues.
Best Regards,
Yingjie Li
@Anonymous
try
Age= CALCULATE(
COUNT(Table[CREATED_ON]),
DATESBETWEEN(Table[CREATED_ON],DATEADD(LASTDATE('Date'[Date]),-320,DAY),DATEADD(LASTDATE('Date'[Date]),-365,DAY) ) )
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |