Forum Discussion

alonb's avatar
alonb
Helper I
8 years ago

DATESINPERIOD Function

Hi Team , 

 

I have a problem with this function . 

When I use with the function in table matrix visual and try to go down(Drill Down) to the second level

The result I get does not match the result I received before i did Drill Down to records.

 

DATESINPERIOD30 = CALCULATE(COUNT(Issta[id]),
DATESINPERIOD(Issta[insert_time],
max(Issta[insert_time]),-30,DAY))

can you help me with this issue ? 

 

Thanks

Alon

 

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi alonb,

     

    Based on my test, if you create a measure DATESINPERIOD30, it can works fine. When you drill down from Year level to Quarter Level, it will count ids between last date for each quarter and maximum date for each quarter back 30 days. You can see attached pbix file.

     

    In your scenario, what's the issue do you mean when drill down to second level? Please clarify it.

     

    Best Regards,
    QiuyunYu