DATESINPERIOD Function

[alonb]

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

[v-qiuyu-msft]

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