Adjust date in date column via a parameter

Hi Tom12 

As tested, if i use the formula "AdjustedDate" in the measure, then add this measure in the visual, it would throw an error.

This is because "DATEADD" function returns a table instead of a list of values.

If you want to adjust date dynamically for a calcuation, for example:

Measure 1 = CALCULATE(COUNT('Table'[Date]),DATEADD('Table'[Date],[Parameter Value],DAY))

It is possible.

But if you want to adjust dates list directly, you could create a simple measure. 

In Power BI, It will increase dates intelligently.

Measure 2 = MAX('Table'[Date])+[Parameter Value]

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.