Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello, I have a small question. I have a column X with 1 2 3 4 5 6 as numbers and i want a column to be added with Y as the same as X but 1st row should be skipped in Y when comparing to X. Like the following one.
X Y
1
2 1
3 2
4 3
5 4
6 5
6
c
Can anyone please suggest me the solution with a DAX code or else anything?
Solved! Go to Solution.
Hi @Anonymous ,
Test the below:
Table2 = DISTINCT(UNION( SELECTCOLUMNS('Table',"X",'Table'[X]),SELECTCOLUMNS('Table',"X",0)))
Y = IF (
Table2[X]=0,
CALCULATE(MAX(Table2[X]),ALL(Table2)),
IF (
CALCULATE (
MAX ( 'Table2'[x] ),
FILTER ( ALL ( Table2 ), Table2[x] < EARLIER ( Table2[X] ) )
) = 0,
BLANK (),
CALCULATE (
MAX ( 'Table2'[x] ),
FILTER ( ALL ( Table2 ), Table2[x] < EARLIER ( Table2[X] ) )
)
)
)
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi @Anonymous ,
Test the below:
Table2 = DISTINCT(UNION( SELECTCOLUMNS('Table',"X",'Table'[X]),SELECTCOLUMNS('Table',"X",0)))
Y = IF (
Table2[X]=0,
CALCULATE(MAX(Table2[X]),ALL(Table2)),
IF (
CALCULATE (
MAX ( 'Table2'[x] ),
FILTER ( ALL ( Table2 ), Table2[x] < EARLIER ( Table2[X] ) )
) = 0,
BLANK (),
CALCULATE (
MAX ( 'Table2'[x] ),
FILTER ( ALL ( Table2 ), Table2[x] < EARLIER ( Table2[X] ) )
)
)
)
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.