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.
Hello!
How can I get the value from previous dates, if my column has more dates than other table?
Solved! Go to Solution.
Here it is,
I have named these 2 tables as A and B
First create a calculated column in the first Table shown in the Picture
DateKEY = A[Date]&A[KEY]
and then create another calculated column to get the revenue
Result=LOOKUPVALUE(A[Revenue],A[DateKEY],IF(ISBLANK(LOOKUPVALUE(A[Date],A[DateKEY],B[Date]&B[KEY])),CALCULATE(MAX(A[Date]),FILTER(A,A[Date]<EARLIER(B[Date]))),LOOKUPVALUE(A[Date],A[DateKEY],B[Date]&B[KEY]))&B[KEY])
Hello!
I need a column, where calculate 'revenue' by date, and key. If date is blank, I need previous value (revenue).
Thanx!
Here it is,
I have named these 2 tables as A and B
First create a calculated column in the first Table shown in the Picture
DateKEY = A[Date]&A[KEY]
and then create another calculated column to get the revenue
Result=LOOKUPVALUE(A[Revenue],A[DateKEY],IF(ISBLANK(LOOKUPVALUE(A[Date],A[DateKEY],B[Date]&B[KEY])),CALCULATE(MAX(A[Date]),FILTER(A,A[Date]<EARLIER(B[Date]))),LOOKUPVALUE(A[Date],A[DateKEY],B[Date]&B[KEY]))&B[KEY])
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |