The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Everyone!
I have 2 tables, one with products and the other with laboratories. I need that both blank spaces have the value of the middle one (1514).
The measure is:
This is the sample file: https://www.dropbox.com/s/lb5cl6r4a152gvc/Sample%20Real.pbix?dl=0
Hi @orghn
The pbix file you provided is deleted , can you provide detail data again ? Also, can you show your needs in the form of data or pictures ? It will help us to deal with the issue easier .
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yetao1-msft,
This is a Sample File:
https://www.dropbox.com/s/jh9ctxatt079dvq/Sample%28Updated2%29%20%281%29.pbix?dl=0
I need to select 1 lab and N products. I need to find the price per month of my product (my_price) and compare to the total_prod_price to find the difference (%) between prices
@orghn , Not very clear.
Try like
Precio_Mio = CALCULATE(MAX(PRECIOS_MENSUALES[PRECIO_ARS]),filter(allselected(LABORATORIOS), LABORATORIOS[DLABORATORIO]=max(LABORATORIOS[DLABORATORIO])))
Hi @amitchandak , I tried that but it´s not working. I need to find the price of a specific product (selecting only 1 lab). After that, I should calculate the price of each product of each lab and find the % between my product and the competitors.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
126 | |
107 | |
87 | |
65 | |
60 |
User | Count |
---|---|
258 | |
121 | |
117 | |
99 | |
79 |