Forum Discussion

shyamji's avatar
shyamji
Helper I
6 years ago
Solved

Last 6 month data with filter

Hi, i want last 6 months data but filter each month data like below DAX CreatedTicket(6Months) = CALCULATE ( COUNT('TicketsDetailMonthly'[TicketId]),FILTER('TicketsDetailMonthly', MONTH('Ticket...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi shyamji ,

     

    I have created a sample for your reference.

     

    Measure = 
VAR sel =
    MAX ( 'date'[Date] )
VAR prese =
    EDATE ( sel, -6 )
RETURN
    IF (
        MAX ( 'Table (2)'[date] ) >= prese
            && MAX ( 'Table (2)'[date] ) <= sel,
        CALCULATE ( SUM ( 'Table (2)'[value] ) ),
        BLANK ()
    )

     

     

    Pbix as attached.

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi shyamji ,

 

I have created a sample for your reference.

 

Measure = 
VAR sel =
    MAX ( 'date'[Date] )
VAR prese =
    EDATE ( sel, -6 )
RETURN
    IF (
        MAX ( 'Table (2)'[date] ) >= prese
            && MAX ( 'Table (2)'[date] ) <= sel,
        CALCULATE ( SUM ( 'Table (2)'[value] ) ),
        BLANK ()
    )

 

 

Pbix as attached.