User Profile

stanislav_dugas

Helper III

Joined 6 years ago

50 Posts3 LikesLikes received3 Solutions

View All Badges

User Widgets

Contributions

Re: Last years quarter end value to be set as opening value for whole next year
Jihwan_Kim Quick question. How would you adjust the function you sent if you have larger data set where you would have another column splitting each year into various segments so that in visual you can filter for individual segment and the logic would still work. ATM you function uses the filter part which eliminates all the slicers in the visuals.
5 years ago Place Desktop
915Views
0likes
0Comments
Re: Last years quarter end value to be set as opening value for whole next year
Thanks alot Jihwan_Kim . Been strugling with it for a while 🙂 your solution worked like a charm.
5 years ago Place Desktop
953Views
1like
0Comments
Last years quarter end value to be set as opening value for whole next year
I am having bellow data set. What i need to do is for every year i need to set the last quarter value from previous year as opening value for whole next year. So for whole 2017 year i would have Opening SE as Q1 2017 = 1 969 015 870 Q2 2017 = 1 969 015 870 Q3 2017 = 1 969 015 870 Q4 2017 = 1 969 015 870 I am strugling with composing the right function. any help with this is appreciated.
Solved
5 years ago Place Desktop
Need Help
1.1KViews
0likes
4Comments
Re: Append Querry DB2 and Txt File not working
Hi Icey thank you for your idea I was able to bypass the issue since it was all about performance. By adding the DB2 source, the performance of loading time for the data deteriorated quite significantly. So What I did was that I refreshed the model before the data entered the DB2 and appended query with .txt. Since it had 0 rows on DB2 the appending worked fine and then I moved the model to reporting server which has much higher computing power then my Laptop and scheduled a refresh there with the full DB2 data. Now it is working fine as the update is happening on the server.
5 years ago Place Desktop
897Views
1like
1Comment
Re: Append Querry DB2 and Txt File not working
This is how the loading looks like:
5 years ago Place Desktop
966Views
0likes
0Comments
Append Querry DB2 and Txt File not working
Hi Guys, I have a problem. I am trying to append 2 querries one has as a source a DB2 connection and another txt.file. When i had this query settup that both had source as txt file there was no problem to append querry but the moment i change the source to DB2 even when the data output is the same i get a problem that queries do not get appended. All that happens is enless loading. And the system is trying to append them but nothing happens even after waiting for a long time. Do you have any idea what could be the problem? Thank you for any advice.
Solved
5 years ago Place Desktop
Need Help
995Views
0likes
4Comments
Re: Sumx with Meassure
Thx alot this solved another problem now my factor is calculated properly even when looking on various countries at once 🙂 thx alot
5 years ago Place Desktop
1KViews
0likes
0Comments
Re: Sumx with Meassure
Perfect this solved my problem Related function brought the expenses into my main table and then i was able to quickly calculate it 🙂 thx alot
5 years ago Place Desktop
1KViews
0likes
0Comments
Sumx with Meassure
Hi Guys i need help with adjusting my sumxfunction. I have 2 tables. 1st: Country Product APN UK A 20 UK B 10 US A 30 US B 10 2nd: Country Expenses UK 100 US 200 Both tables have relationship via Country. And what i would like to calculate is the expeses after aplying factor per individual product. Expenses are allocated via the amount of Premium (APN). Hence i created meassure to have factor for individual product and country like this since i will be looking at the allocation only per individual country. Factor = DIVIDE(SUM(Data[APN]),CALCULATE(SUM(Data[APN]),ALLSELECTED())) So for UK the visual will look like this. Country Product APN Factor UK A 20 0,67 UK B 10 0,33 And now i need to to do sumx where i need to split the expenses from the second tabel and bring it into first one. What i made is this but it is not working as it should. SUMX(VALUES(Data[Product)]),[Factor]*SUM(Expenses[Expenses])) My final visual should look like this but instead i get 300 for each product. Country Product APN Factor Expenses UK A 20 0,67 67 UK B 10 0,33 33 Any idea what am i doing wrong? Thank you.
Solved
5 years ago Place Desktop
Need Help
1.1KViews
0likes
4Comments
Re: Create stacked column chart with Grandtotals and double split.
amitchandak Based on your instructions i was able to figure out most of the visual. Maybe just one thing do you know if its possible to add change % that i have in the expected visual? To show the percentual change between two period for each group. So % change for UK between P9 and FA then % change for UK Globals between P9 and FA and same for UK Total.
5 years ago Place Desktop
705Views
0likes
0Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.