You saved my life! Was trying first to set up a whole nee power Bi report in another currency . Thanks!
@CurbalEN
3 жыл бұрын
🥳🥳
@loyalindian8986
2 жыл бұрын
Awesome feature! great learning, thank you!!
@excelisfun
7 жыл бұрын
Thanks for the currency switch : )
@CurbalEN
7 жыл бұрын
+ExcelIsFun You welcome! Really neat solution for International companies :) /Ruth
@yowag38
4 жыл бұрын
You're a star. Thanks you so much for sharing this useful tip.
@CurbalEN
4 жыл бұрын
Thanks to you for watching :) /Ruth
@Ferruccio_Guicciardi
6 жыл бұрын
Very handy. Thanks for sharing.
@CurbalEN
6 жыл бұрын
Glad it helped :) /Ruth
@markstleger4071
3 жыл бұрын
Great video. Sincere thanks!!
@CurbalEN
3 жыл бұрын
😊
@Entertainmentmod
2 жыл бұрын
Great. Its working my side also
@CurbalEN
2 жыл бұрын
Yey!
@krishj8011
9 ай бұрын
nice tutorial...
@preethis2975
3 жыл бұрын
thank you for the tip
@amitshukla189
7 жыл бұрын
awesome video
@CurbalEN
7 жыл бұрын
+Amit Shukla Thanks Amit! /Ruth
@EminUzunN
7 жыл бұрын
You have video about everything :))
@CurbalEN
7 жыл бұрын
+Emin Uzun 😂Noy yet, but hopefully soon! /Ruth
@SwapnilKochetaa
6 жыл бұрын
Thanks a lot for the video and sample file. I was just playing with the file and found an interesting situation which didn't work... What If I want to : 1. Display Product Id, Product name and Total Sales Measures created 2. I want to slice/filter on product by id and name. As soon as I add ID from product table, The table visual has loads of duplicate junk rows, I can't figure out why , and how to avoid these (Except may be using a calculated column in Order_details table to have product name)
@maickelhounsonlon3548
3 жыл бұрын
Hello, Thank you so much for this amazing video. It helps me a lot . Can you tell me please i need to create 10 measures if I have 10 columns to convert ? (In this video, you convert one column Total sales). Thank you for the help :)
@bernatoparlar6320
3 жыл бұрын
Great tutorial! This creates a text field and works perfectly with Table and Matrix - Is there a way that we can format this as a whole number so we can display these in bar charts as well?
@jananiingarshal1777
2 жыл бұрын
Even I need the same one. Let me know if you find any. I want to display in Bar Chart
@jhoottube
3 жыл бұрын
Hi, Thanks for the video. selected currency = values(currency[currency]) not working in my case. do I need to create a relationship bw these two tables first?
@majdyazigi8185
7 жыл бұрын
Great Video as usual Curbal, I have two questions for you please 1) Using slicers will allow the user to have multiple choices, how can we use something like radio button to select only one value at a time?. 2) Can you make a video to explain to us how to get streaming data from internet, and where can we find web sources of data to provide common subjects, like currencies rates, football results, weather forecasts, etc... so we can use it in our reports with online data, rather than just typing it in a static table. Thank you
@CurbalEN
7 жыл бұрын
Hi Majd, 1.You can return a blank using DAX if a user selects more than one choice. I dont know if there is a custom visual for radio buttons, but you can create your custom visuals if you need to. 2. Here it is an example of a web source for currencies: www.x-rates.com/historical/?from=EUR&amount=1&date=2014-06-03&date=2014-06-03 Here is a video on how create those queries: kzitem.info/news/bejne/l4aQuY5rbJuEoqg As to why I enter data statically, I have in previous videos used web live data, but with time those sources either disappeared or they becomed paid sources preventing the tutorial from being reproduced. /Ruth
@majdyazigi8185
7 жыл бұрын
I watched the video and it is great, is there a website or web source to choose from multiple subjects, Google Analytics for example?
@CurbalEN
7 жыл бұрын
+Majd Yazigi Not sure what you mean, but if you want to connect to google analytics, here is a video on how to that: m.kzitem.info/news/bejne/toCJx6SdsKtmeoY /Ruth
@manuprakash1989
6 жыл бұрын
this is what i want to implement in our project..thank you Curbal..is there any way we can do this with two drop down tiles..
@CurbalEN
6 жыл бұрын
+manu prakash Not sure what you mean... But download the sample file and try it to see if it works. /Ruth
@kuakers
2 жыл бұрын
thx for the tutorial, i have a question, what if yo matrix currency have diferent currency?
@maricelvelasco6377
4 жыл бұрын
Hello, may I ask what query or measure did you used in total sales (sek)?
@mag4428
6 жыл бұрын
Many thanks for that helpful video. Do you know how I can put this values into a bar chart and filter this with slicers? Currently I can't move the Total Sales (selected currency) into the value box of a chart. Thanks in advance
@CurbalEN
6 жыл бұрын
Hi Ma, Would you mind posting your question in the power Bi Community? I am on vacation. Thanks! /Ruth
@JoaoR91
4 жыл бұрын
Thank you for the explanation, your videos are awesome. In my projecet i do need to change the currency rate base on a value defined by the user on the report. Do you have some idea?
@@CurbalEN Great video! I expressed myself wrong. I'm trying to build a report where the user can set the value of the currency in the own report, like a parameter. I found a way creating a table and doing a measure with it, its a workaround but its working. Thanks for your support, your videos are great.
@vasu4us
3 жыл бұрын
@@JoaoR91 I am trying to do something similar as a POC before trying it in enterprise reporting tool. Can you share the link if you have posted the solution or share the detail
@ambregiustiniani7633
5 жыл бұрын
What if there are several years so several exchange rates ? Thank you very much
@CurbalEN
5 жыл бұрын
Give details of your case in the power bi community and you will help in no time! /Ruth
@diepdo9408
Жыл бұрын
Hi! What if i have multiple rates (according to months for one currency) and I want to select the most recent month rate, then how could I store only the most recent rate in the selected currency measure? Thanks
@jananiingarshal1777
2 жыл бұрын
Informative! but the same DAX is not working when I put that in Bar Chart or any other visuals. Please advice
@TheWanderercontent
Жыл бұрын
What if the Total sales are in multiples currencies and I want to convert them a single currency like EUR ?
@ayushurmaliya5217
2 жыл бұрын
such an awesome video, I have a doubt, what if we have data for many years, and for each year we have different conversion rates for each currency for example FY2017 Eur exchange rate 1.77, FY2018 Eur exchange rate 1.82 how to work in this scenario?
@lmotevali1452
2 жыл бұрын
thanks when you want this measure to a line or bar chart it is wrong becouse format convert to text...can you help me?
@Memory-lane29
2 жыл бұрын
Hi, what is the relationship between the currency table and your data table? I have error with selected currency formula.
@hafizasim4245
2 ай бұрын
How about there are bank transactions in multiple functional currencies and one presentation currency? Need. a slicer with a choice between functional and presentational currency If u select presentation currency the numbers will convert to USD for example and when yoi select functional currencies the columns or numbers will convert to bank respective currencies ie pound Eur AED etc
@GerardoMujicaArevalo
6 жыл бұрын
Muchas gracias por tus aportes Ruth son una excelente guía para los que recien nos adentramos en el mundo del powerbi, respecto a este truco, se podría realizar teniendo 2 slicers, es decir Currency y año?? Eh tradado de integrarlo, pero creo que mis conocimientos no son lo suficientemente amplios para hacerlo funcionar. De antemano gracias.
@CurbalEN
6 жыл бұрын
+Gerardo Mujica Arevalo Si claro, simplemente añade el año como slicer (si no recuerdo mal) :) /Ruth
@GerardoMujicaArevalo
6 жыл бұрын
Muchas gracias por tomarte el tiempo de responderme, creo que plantee mal mi pregunta. Mil disculpas, Por ejemplo: en mi hoja tengo 2 filtros (ciclo, encuesta).. entonces si yo filtro por ciclo 1, quiero que mi measure me muestre ciertos valores, si selecciono ciclo 2 y en mi filtro de encuesta selecciono 1er. Encuesta, entonces ese measure debe de mostrar otro valor. o me funciona cuando tengo seleccionado algún Ciclo, si no selecciono ninguno me muestra error en el measure.. Me podrías apoyar por favor. Mil Gracias!! Saludos desde Mexico
@CurbalEN
6 жыл бұрын
+Gerardo Mujica Arevalo Hola Gerardo! Mexico, que maravilla :) A ver, podrías poner la pregunta en la comunidad de Power BI? Pon también un ejemplo de tus datos! /Ruth
@GerardoMujicaArevalo
6 жыл бұрын
Claro que sí Ruth, mil gracias !! :D
@CurbalEN
6 жыл бұрын
+Gerardo Mujica Arevalo Mexico es uno de los países que tengo que visitar, por lo que me cuentan, impresionante :) Saludos, /Ruth
@ranorahul4099
6 жыл бұрын
In the switch case statement what is that "TOTAL SALE(sek)" mean and what values does it have?
@CurbalEN
6 жыл бұрын
Hi Rano, You can download the file in the description box to see how it is built. /Ruth
@gopid6342
4 жыл бұрын
Can we use it in any visual like piechart, donut series ... ? If it's possible please post the video .
@gopid6342
3 жыл бұрын
Can we apply this in any visualization like Pie,Donut, Bar caht, etc...
@sahulhameed6144
7 жыл бұрын
I can't use the format function in chart because format function changes the measure to a text format. is there anyway to use format in chart rather than table?
@CurbalEN
7 жыл бұрын
+sahul hameed Hi Sahul, I got the same question earlier today, I need to check what can be done and let you guys know about it! /Ruth
@shan2391
3 жыл бұрын
@@CurbalEN hi just checking if you had an solution for this?
@adityaagrawal9736
6 жыл бұрын
How we can create Dynamic/Variable Column Header Names changing with Slicer?
@LossevSergey
7 жыл бұрын
What if you have variable number of currencies? And table of currencies is provided by datamodel and is downloaded from external web resource for example
@CurbalEN
7 жыл бұрын
+Sergey Lossev Hi Sergey, you should be able to use the same method. Anything in particular you don't think will work? /Ruth
@SwapnilKochetaa
6 жыл бұрын
Is there a way to handle this situation when supported currency may be added and I don't want to replicate that swicth case line again ? Also, We get exchange rate on a Monthly basis .. Any example would be a great help
@CurbalEN
6 жыл бұрын
Hi! Post a case in the power bi community and give as much details as possible to get help. Thanks! /Ruth
@bhavnachalise
9 ай бұрын
Will this work for graphs as well?
@sanj3189
Ай бұрын
Hi This will not work in the line charts then what is the approch i can change
@saraysmusic
4 жыл бұрын
Hi!! I found your video really interesting. I would like to know if you could help me because my scenario is a little bit complex. I have inputs in different currencies and then I want to create a sales report where you could select in which currency you want to see the data. Another complexity is that I have a daily exchange rate for 7-10 currencies. How could I built it?Thanks!!
@CurbalEN
4 жыл бұрын
Hi Saray, Could you post in the power bi community? Give as many details as you can get support quickly! /Ruth
@RajeevKumar-fm5xx
3 жыл бұрын
Please clarify the measure which is multiplying with values.
@nimikajadav3004
Ай бұрын
I want to get rate from users then want to convert into that rate . how to do ? like if choosed INR then show INR value, if choose USD then pur rate from numeric range parameter and convert into USD using given rate , not manually put into table then convert
@atharnayab3547
6 ай бұрын
you have not explained from where Total sales(sek) come from? for me it is giving error due to this
@mathijs9365
7 жыл бұрын
Cant u use lookupvalue to look up the currency rate. So u dont have to use switch and typ a line for every currency
@CurbalEN
7 жыл бұрын
+Mathijs Mmmm do you have a sample report? I would love to do a video about it :) /Ruth
@mathijs9365
7 жыл бұрын
Curbal I found below article. At first I thought related would be the trick. But in fact lookupvalue doesnt need a relation between tables. www.dutchdatadude.com/power-bi-pro-tip-lookupvalue-function/
@CurbalEN
7 жыл бұрын
+Mathijs Great! Will read and make a video, thanks for the tip 😃! /Ruth
@chengwang411
2 жыл бұрын
My boss wants to put a period slicer and currency slicer. I'm at loss as to how to convert the YTD figures into EUR. Because there're multiple rates over the year. Any hints?
@KrishnaReddy-dc3yk
3 жыл бұрын
Hi Ruthu, It's cool....but if I have data from 2000 to 2020 , so currency also changed in year bases then how can in wrote? Thanks in advance
@keertichouhan5483
3 жыл бұрын
currency rate changes on daily basis ..how can we give changed value input in power Bi?
@gopid6342
3 жыл бұрын
When I applied this in pie chart, it can't apply DAX measure in value field, because data type issue but working fine in table visualization
@sarathysaru2104
3 жыл бұрын
i find the same issue, I couldn't use converted values in graphs
@SwapnilKochetaa
6 жыл бұрын
is Total Sales a Measure ? Because when I use similar formula in my table, I get an error that It returned multiple values (I am applying this on a column).
@CurbalEN
6 жыл бұрын
It might be a calculated column, I don’t remember exactly. The download doesn’t work? /Ruth
@SwapnilKochetaa
6 жыл бұрын
unfortunately download doesn't work
@CurbalEN
6 жыл бұрын
Ok, got you! I updated the link, please try again. /Ruth
@DanceSongsTC
5 жыл бұрын
Same problem at my end too. Can you please update the link as it doesn't work again - Thanks
@robnicruby6594
4 жыл бұрын
Hi, Having some trouble implementing this approach and cant figure out why: Measure: Selected Currency = VALUES('Currency'[Currency]) Error: Calculation error in measure 'Currency'[Selected Currency]: A table of multiple values was supplied where a single value was expected?
@CurbalEN
4 жыл бұрын
Your measure returns a table instead of a value. That is what the error is telling you. /Ruth
@robnicruby6594
4 жыл бұрын
@@CurbalEN This is what is confusing me, I have chosen the column rather than the table.
@johnnyaraujo1148
3 жыл бұрын
not workking for me, its works only if any option is selected. If nothing is selected, its get a error
@nithyanandhanjayakumar6535
2 жыл бұрын
I need to convert the Currency on the Periodic wise, Like for the Quarter Q1 to Q4 the conversion rate will be varying. So the total sales of the year will calculate based on the different conversion rate. Please help me on this.
@johanberggren5193
2 жыл бұрын
Did you find a solution? I'm also stuck with this :)
@madalyon7958
5 жыл бұрын
How can I create Total Sales(Sek) measure. What is it's DAX Query? I used VALUES but it did not work. Error is like this => A table with multiple values is provided while waiting for a single value.
@CurbalEN
5 жыл бұрын
It depends on what you are trying to do and how your model looks like. Post in your question in the power bi community and give as many details as possible to get specific help! /Ruth
@MrSheentv
6 жыл бұрын
grate - what happens if the currency rate changes every day?
@CurbalEN
6 жыл бұрын
Then you need to connect to the source instead :) /Ruth
@MrSheentv
6 жыл бұрын
?Thank you - do you mean to bring all the data to the fact table .I have 20 currency rate that changes every day
@CurbalEN
6 жыл бұрын
Yes, if you only need the daily rate and the API allows it, you can import only that. /Ruth
@mickaellozach4568
5 жыл бұрын
@@CurbalEN my currency rate also change every quarter but I would like to keep the history and apply the rate of the relevant quarter. For instance if data are entered on Q1 2019 the rate used will be different from the rate I would have if the data had been entered on Q4 2018. Do you have a solution for that ? Thank you Mickaël
@CurbalEN
5 жыл бұрын
Hi Michael, I don’t have a video for that, so please ask in the Power Bi community to get help. Here is how and why: m.kzitem.info/news/bejne/0I58tZmYrqiDrWU /Ruth
@sabyasachighoshbabu640
5 жыл бұрын
Hello, Here is the detailed note about POWER BI issue. - I need a POWER BI report in USD format, but after formatting also i'm seeing reports in INR format. I've tried all the formatting set up in power BI, but still seeing the same issue. Assumption: When I downloaded POWER BI, my system set up in INR, but now I changed as USD. But it's not reflecting in POWER BI. Please assist me to solve the same.
@CurbalEN
5 жыл бұрын
Please report your issue here: Issues.powerbi.com /Ruth
@sabyasachighoshbabu640
5 жыл бұрын
@@CurbalEN thank you.
@LuisLopez-sc1qc
7 жыл бұрын
muy bueno pero una consulta donde dice ...total sale )select currency).. lo quiero que el resultado tambien me muestre decimales me ayudarias graciass
@djeritorres
7 жыл бұрын
LUIS ALBERTO LOPEZ CHAVEZ Solo tendrías que seleccionar la medida y darle formato de decimales. Saludos
@CurbalEN
7 жыл бұрын
+LUIS ALBERTO LOPEZ CHAVEZ Hola Luis Alberto, formatea la formula para que te de los decimales como lo harías en Excel, /Ruth
@CurbalEN
7 жыл бұрын
+djeritorres Gracias djerirorres! ;) /Ruth
@djeritorres
7 жыл бұрын
Curbal Un placer. Saludos...
@CurbalEN
7 жыл бұрын
+djeritorres igualmente :)
@sarathysaru2104
3 жыл бұрын
DAX is not picking up my currency field (in your case Total sales(SEK))
@varunjain3829
3 жыл бұрын
why we can not use the currency symbol dynamic when we use any pia chart of graphs , if we can use please tell me how?
@CurbalEN
3 жыл бұрын
You can do it now why the tabular editor. Search on Google!
@varunjain3829
3 жыл бұрын
@@CurbalEN I want to it on Line chart can we do it here.
@CurbalEN
3 жыл бұрын
I dont think line charts are supported yet.
@varunjain3829
3 жыл бұрын
@@CurbalEN Thank you for your reply
@MarkCBB86
7 жыл бұрын
Very Cool Video, I actually did something similar with Units to Value switch, however, I am still trying to find a way to get it into a chart because obviously Format Changes to Text - Any ideas around this?
@CurbalEN
7 жыл бұрын
+Mark Blackburn Hi Mark, not sure what you mean.. what are you trying to do? /Ruth
@MarkCBB86
7 жыл бұрын
Very similar to what you have done in this video - if you changed that table to a bar chart and use the measure you created that has the Format function - the Bars in the chart will not appear as the value is not a numeric value but a text value - so I guess my question is, is how can this be implemented into a Chart vis.
@CurbalEN
7 жыл бұрын
+Mark Blackburn Gotcha! I did this video a while ago, had to go and check. What happens if you multiply the measure by 1? Haven't tried it myself, but is should work(?) /Ruth
@EminUzunN
7 жыл бұрын
Hey, I would put original amount to values and put the conversion to tooltips. It may solve your problem.
@EminUzunN
7 жыл бұрын
I tried "1" :) Got big X. It messes the formula :)
@abhinashduggi4955
2 жыл бұрын
How to format that values into Millions, Thousands
@brijendraydv
7 жыл бұрын
how the multiplication happening without relationship on currency?
@brijendraydv
7 жыл бұрын
i dont know why im getting this error-A table of multiple values was supplied where a single values was expected.could you pls help on this.
@CurbalEN
7 жыл бұрын
+brijendraydv Hi, The necessary value is passed to the Dax measure :) /Ruth
@CurbalEN
7 жыл бұрын
+brijendraydv You are missing a VALUES somewhere.. /Ruth
@ozzLemmSa
4 жыл бұрын
Is it possible to get the exchange rates from www.xe.com website and create dynamic exchange rates? Thanks in advance!
@CurbalEN
4 жыл бұрын
If they have an api, it should be possible. /Ruth
@rodribezul
7 жыл бұрын
Total Sales (selected currency) var = var Lnvalor = [Total sales (sek)]*VALUES('Currency'[Currency Rate]) VAR LcFormato = SWITCH(TRUE(); [Selected currency]="EUR";"€0,00"; [Selected currency]="USD";"$0,00"; "0,00kr") RETURN FORMAT(LnValor;LcFormato)
@CurbalEN
7 жыл бұрын
+Rodrigo Bedoya Zuluaga Hola Rodrigo, KZitem mando este comentario al spam! Ya está aprobado. /Ruth
@edgarsan71991
5 жыл бұрын
Amazing video I want a child with you jaja
@ameyjawalikar7987
5 жыл бұрын
Hi Ruth, This video cannot be used for currency conversion as we also have date field for consideration. This is just slicer application you are showing in the video. No offence your contents are good but in this video its not. Thanks
@CurbalEN
5 жыл бұрын
Hi Amey, What you are mentioning is a different case that what I explain in this video, so in that case you are right. In a future video I can cover your scenario. Ruth
Пікірлер: 143