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,
I'm a beginner with DAX and power bi, and I would appreciate your help.
Basically, I have a table with similar columns A,B,C, but I don't know how to create a formula for D.
Basically I have different budget versions within the same year, but I want the report to only display the latest one from the current year. Sometimes we have budgets in the system that have higher version numbers (N) than the current one for this year, so simply displaying the highest number doesn't work.
thanks!
Solved! Go to Solution.
Hi @Anonymous,
Please refer to below calculated column.
Max N current year = CALCULATE ( MAX ( Table7[N] ), FILTER ( ALLEXCEPT ( Table7, Table7[proj] ), Table7[year] = YEAR ( TODAY () ) ) )
Best regards,
Yuliana Gu
Hi @Anonymous,
Please refer to below calculated column.
Max N current year = CALCULATE ( MAX ( Table7[N] ), FILTER ( ALLEXCEPT ( Table7, Table7[proj] ), Table7[year] = YEAR ( TODAY () ) ) )
Best regards,
Yuliana Gu
worked perfectly, thank you very much!
C.
Are cells D5/D6 3 rather than 2 by design?
Hi
Each project has its own versioning in Oracle. What I meant was that for P002, the highest (ie current in 2018) budget version is 3.
However for P001, the current 2018 budget version is 2 (3 is in 2019).
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |