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 am a fairly new user to PowerBi and I have been struggling to understand how to calculate data in a table, specifically how toadd a new column to a visualization table that I made with filters and specific data chosen. What I mean by this is that I made a table where i filtered by specific rows and dates and now with the information shown in the visualization i want to be able to create a calculation, but only with the information shown!
I would also like to know if i can do a "VLOOKUP" in PowerBi!
Thank you very much!
Solved! Go to Solution.
Hi @Anonymous ,
You can create measures like this, set its value as 1 and put it in the visual filter to do the calculation and filter data in the visual:
Measure =
IF (
SUM ( 'Table 1'[Value] ) >= 15
&& MAX ( 'Table 1'[Column] ) <> BLANK (),
1,
0
)
In addtion, in power bi, you can use Lookupvalue() function to replace Vlookup():
Column = LOOKUPVALUE('Table 2'[Category],'Table 2'[ID],'Table 1'[ID])
You can refer this article: DAX In Power BI - How To Use LOOKUPVALUE() Function
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You can create measures like this, set its value as 1 and put it in the visual filter to do the calculation and filter data in the visual:
Measure =
IF (
SUM ( 'Table 1'[Value] ) >= 15
&& MAX ( 'Table 1'[Column] ) <> BLANK (),
1,
0
)
In addtion, in power bi, you can use Lookupvalue() function to replace Vlookup():
Column = LOOKUPVALUE('Table 2'[Category],'Table 2'[ID],'Table 1'[ID])
You can refer this article: DAX In Power BI - How To Use LOOKUPVALUE() Function
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |