User Profile
kasiaw29
Resolver II
Joined 7 years ago
User Widgets
Contributions
Re: Get currency exchange rate per each quarter within dataset
I managed to fix my own problem by using the following Quarterly Rates = SUMMARIZE( 'IFS Currency Exchange Rates', 'IFS Currency Exchange Rates'[CURRENCY_CODE], 'IFS Currency Exchange Rates'[Qtr], "Max Date", MAX('IFS Currency Exchange Rates'[VALID_FROM]), "Rates", LOOKUPVALUE('IFS Currency Exchange Rates'[CURRENCY_RATE], 'IFS Currency Exchange Rates'[VALID_FROM], MAX('IFS Currency Exchange Rates'[VALID_FROM]), 'IFS Currency Exchange Rates'[CURRENCY_CODE], 'IFS Currency Exchange Rates'[CURRENCY_CODE]))Get currency exchange rate per each quarter within dataset
Hi all, I've been going around in circles with SUMMARIZE, GROUP BY with no effect. Here's my problem: I have a currency exchange rate table with the following columns: Currency Code, Currency Rate, Valid From, Qtr Above data is entered by my finance dept. on a monthly basis into our source system. I'm retrieving all of it but I need to find out what the currency rate was at the end of each Qtr, so the ideal output (probably as a new table) would look like: Currency Code Currency Rate Valid From AUD 1.777254 01/12/2022 BRL 6.332406 01/12/2022 EUR 1.169222 01/12/2022 USD 1.231575 01/12/2022 ZAR 20.184808 01/12/2022 AUD 1.790811 01/03/2023 BRL 6.268214 01/03/2023 EUR 1.13509 01/03/2023 USD 1.2234 01/03/2023 ZAR 21.812421 01/03/2023 CNY 8.368982 01/03/2023 I usually try to solve things as much as I can on my own before turning to the community. I could really appreciate someone shining some light on this, I must be missing something.'Object reference not set to an instance of an object
Hi all, I've been getting this error message since Friday/Saturday on PowerBI service for all reports that are connecting to an Oracle DB source stopping all the report refreshed. Oracle Clinet and PowerBI are both 64-bit version, there's been no changes applied to anything other than gateway updated to April version the week prior. Everything worked fine until Friday. Also reciving this error when refreshing reports on PowerBI desktop: Has anyone got any ideas on how to solve it?Rolling Sum between two dates
Hi community, I'm hoping for someone's assistance on a measure I'm trying to create. I have a table with orders, their total value and date when it was created and invoiced, see below: Let's use highlighted line as an example Created 25/05/2021 and invoiced on 08/09/2021 of a value of 7,133.49. I want to create a measure where 7,133.49 shows in May, June, July and droppes of August so it almost rolls into each month from created until it's invoiced. I tried some measures using DATESBETWEEN or below: Total Booked Open = CALCULATE(SUM('Customer Orders'[BOOKED_VALUE]), FILTER( 'Calendar', 'Calendar'[Day] >= MIN('Customer Order Dates'[Date Entered]) && 'Calendar'[Day] <= MAX('Customer Order Dates'[Invoiced Date]))) But it's not working quite as expected. Any advice would be wonderful. Thanks, KasiaIncremental Refresh - Keep yesterday's data and refresh today's.
Hi all, I'm setting up incremental refresh for the first time with one of my reports. I'm most likely doing something silly but the main goal here is to load the data in and only refresh the next day's data, i.e. if I load my data in I want to keep it all and perform a refresh tomorrow to bring in new data. I thought I had it set up right in the service but I checked my report and it's empty. I've got my custom filter set up as such and incremental refresh as such I see that it says data will be incrementally refreshed from 17/08/2022 to 17/08/2022 which means yesterday and override yesterday's load which I don't want to do. Data in the table changes every day and what I'm trying to achieve with this is to capture daily changes in data via incremental refresh to perform trend analysis of it.
