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,
Im new to Power BI, I would like to find the value next month time on the same case
I'm building a report from the data like below:
Name | Temp Value | Prev Value | Date |
01/01/2019 | A | 8,154,159 | |
02/01/2019 | A | 8,440,583 | |
03/01/2019 | A | 5,467,687 | 5,343,627 |
01/01/2020 | A | 10,862,462 | |
02/01/2020 | A | 6,470,157 | |
03/01/2020 | A | 6,250,878 | |
01/01/2021 | A | 187,845 | 21,960,681 |
02/01/2021 | A | 8,718,120 | |
03/01/2021 | A | 5,993,100 | |
01/01/2022 | A | 12,234,775 | |
02/01/2022 | A | 9,988,616 | |
03/01/2022 | A | 6,745,904 | 9,733,571 |
01/01/2020 | B | 4,513,172 | |
02/01/2020 | B | 3,609,276 | |
03/01/2020 | B | 2,075,878 |
THE EXPECTED OUT PUT IS
I have tried with the calculate and the lookupvalue function without any luck.
Hope that someone can be of help!
Best regards
Solved! Go to Solution.
@buithai108 , Try like
new column
next day = sumx(filter(Table, [Name] = earlier([Name]) && [Date] = earlier([Date])+1 ),[Prev Value])
Previous year same day =
var _day = date(year([Date])-1, month([Date]),1)
return
sumx(filter(Table, [Name] = earlier([Name]) && [Date] = _day ),[Prev Value])
Wonderful, thanks!
@buithai108 , Try like
new column
next day = sumx(filter(Table, [Name] = earlier([Name]) && [Date] = earlier([Date])+1 ),[Prev Value])
Previous year same day =
var _day = date(year([Date])-1, month([Date]),1)
return
sumx(filter(Table, [Name] = earlier([Name]) && [Date] = _day ),[Prev Value])
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 |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |