Forum Discussion
Power BI DAX
amitchandak , Greg_Deckler , parry2k Date = ADDCOLUMNS ( CALENDAR (DATE(2010,1,1), DATE(2050,12,31)), "DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ), "Year", YEAR ([Date]), "Quarter", "Q...
amitchandak
Super User
Super UserAnonymous , seems fine to me at first look try like.
Application Count =
var _StartDate = CALCULATE(MIN('Date'[Date]),ALLSELECTED('Date'[Date]))
vare _EndDate = CALCULATE(MAX('Date'[Date]),ALLSELECTED('Date'[Date]))
return CALCULATE(
COUNT(
'App'[app_id]),
FILTER('App',
'App'[start_date_time] >= _StartDate,
'App'[end_date_time] <= _EndDate
)
)
If it did not work. Can you share sample data and sample output in table format?
@amitchandak - Thank you for the help, you managed to resolve i was facing that issue due to datetime.
- Greg_Deckler
Community Champion
Anonymous - Glad you got it!
