Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI DAX

Date =
ADDCOLUMNS (
CALENDAR (DATE(2010,1,1), DATE(2050,12,31)),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ([Date]),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" )
)
 
StartDate = CALCULATE(MIN('Date'[Date]),ALLSELECTED('Date'[Date]))
EndDate = CALCULATE(MAX('Date'[Date]),ALLSELECTED('Date'[Date]))
 
Application Count =
VAR _Count = CALCULATE(
COUNT(
'App'[app_id]),
FILTER('App',
IF(
AND(
'App'[start_date_time] >= [StartDate],
'App'[end_date_time] <= [EndDate]
),
1,
0
)
)
)
RETURN IF(ISBLANK(_Count),0,_Count)
 
When i select date between 15-aug-2020 & 15-aug-2020 in Date slicer , then my Application Count is giving Zero.
Any Help.??

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , 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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      @amitchandak - Thank you for the help, you managed to resolve i was facing that issue due to datetime.