Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Is there a way to convert the following calculated column into a measure? Due to the size of the report, a calculated column is throwing out a memory error.
Calculated column:
Thank you
Solved! Go to Solution.
Hi
I think i found a solution
I changed the calcuation to read the following:
I now get the same result:
Thank you!
Hi @ClaireBear not enought infos what is grain of data you have in model and expected level of output. Still, try Measure test
PreviousValue Measure test =
VAR PreviousRow =
TOPN (
1,
FILTER (
Fact_PO,
Fact_PO[Doc. Date] < MAX ( Fact_PO[Doc. Date] )
&& Fact_PO[Material] = SELECTEDVALUE ( Fact_PO[Material] )
),
Fact_PO[Doc. Date], DESC
)
RETURN
MINX ( PreviousRow, [Net Price ZAR] )
Proud to be a Super User!
Hi
Thank you again, The measure unfortunaly returns a blank column.
The table below shows the example data, and the format/structure required.
- There are 2 products with a "Net Price Zar" column by doc date.
- I have added a calculated Column (Calculated Column_Previous Product Price) which shows me the exact result i would like as a measure.
- I want to use a "Measure" instead of a calculated column and get the same result as the "calculated column_previous product" below, same grain of data.
- Even though the calculated column results are correct, it is throwing out a memory error with the live data which is over 100 000 rows so the calculated column is not suitable.
- Most examples available illustrate an index or a date with the previous value calculation which is great, but my issue is that i need the date and the previous value by product in the calculation.
So i would like the measure to show the same results as the calculated column in the example below.
I hope this makes more sense, i appreaciate any advice.
Hi
I think i found a solution
I changed the calcuation to read the following:
I now get the same result:
Thank you!
Hi @ClaireBear
So you want "just" previous row value? Your TOPN misslead me 🙂
The previous row value is based on two columns:Fact_PO[Doc. Date] and Fact_PO[Material]
Proud to be a Super User!
Hi @ClaireBear simple create new measure with your definition.
Proud to be a Super User!
Hello, thank you.
I did try this but it throws out an error:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
85 | |
70 |