Hi All. Got a curly one here. I am working with a table which has placements. The data is from 2015, In order to calculate the conversion rate, I need to select records from 2015 uptto 60 days prior from today (which is going to rolling on daily basis) .I have been using a calculate formula for conversion rate (which is simply placements / Claims) with dateadd function (date, -2, months). The formula works fine when I view this on a card visual but when I pull it on a table against state, site or any other field from the same table, it throws an error "DATEADD expects a contigous selection when date column is not unique, has gaps or it contains time portion".

Hi Anonymous , You may create measure like DAX below. Measure= CALCULATE(<claim ID / Placements measure or coulmn>,FILTER(ALLSELECTED(Sales),Sales[Date]<=DATE(YEAR(TODAY()), MONTH(TODAY())-2, DAY(TODAY())))) Best Regards, Amy Community Support Team _ Amy If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DATEADD Function | Microsoft Fabric Community

Forum Discussion

Related content

DATEADD function

DATEADD Function

Function Dateadd problem

Help with DATEADD function

DATEADD using EARLIER function