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,
I have two tables, what I want the column to do is to calculate the last value of the column number in the new column, given that I don't have the number for 2020 I am fixing the value of year in the second line of the formula. However the formula does not work as expected only working for the rows of 2019 not 2018,2020.
Cuadrante = IF(ISBLANK(CALCULATE(FIRSTNONBLANK(T2[NUMBER],TRUE()),FILTER(T2,T2[YEARDNI]=T1[YEARDNI]))),
CALCULATE(FIRSTNONBLANK(T2[NUMBER],TRUE()),FILTER(T2,T2[YEARDNI]=CONCATENATE("2019",T1[DNI]))),
CALCULATE(FIRSTNONBLANK(T2[NUMBER],TRUE()),FILTER(T2,T2[YEARDNI]=T1[YEARDNI])))
Table 1
YEARDNI | YEAR | DNI | NEWCOLUMN |
20201 | 2020 | 1 | 8 |
20191 | 2019 | 1 | 8 |
20181 | 2018 | 1 | 3 |
Table 2
YEARDNI | YEAR | DNI | NUMBER |
12019 | 2019 | 1 | 8 |
12018 | 2018 | 1 | 3 |
Please your kind help
Solved! Go to Solution.
Ended up duplicating the data of the year 2019 and changing it to 2020. It works for now
Hi,
Table 1 is the expected output, Table 2 is the source data. What I want it to do is to select the 2019 when there is no 2020 in the source data but when hardcoding it only works for the Table 1 Year 2019.
Thanks for the help,
Ended up duplicating the data of the year 2019 and changing it to 2020. It works for now
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |