Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
Solved! Go to Solution.
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.
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.
How to Generate New column by using Date & measure2
Ex:- Date Measure2 Day'sDiff
01-01-2018 04-01-2018 3
Thank you
naveen
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |