Forum Discussion
Adjust date in date column via a parameter
Hi
I am trying to plot transactions values by dates where I have adjusted the value and date via parameters.
I have created a measure for the adjusted value:
however I am struggling to adjust the date in the same way:
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.
3 Replies
v-juanli-msftCommunity Support
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.- Thanks Maggie, that works really well
Tom How to Generate New column by using Date & measure2
Ex:- Date Measure2 Day'sDiff
01-01-2018 04-01-2018 3
Thank you
naveen
