Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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! Go to Solution.
is this what you want?
Column = MAXX(FILTER('Table (3)',year('Table (3)'[Date])=year(EARLIER('Table (3)'[Date]))-1&&QUARTER('Table (3)'[Date])=4),'Table (3)'[Closing SE])
Proud to be a Super User!
Hi, @stanislav_dugas
Please check the below picture and the sample pbix file's link down below.
I tried to create a sample pbix file based on the explanation.
It is for creating a measure.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
Hi, @stanislav_dugas
Please check the below picture and the sample pbix file's link down below.
I tried to create a sample pbix file based on the explanation.
It is for creating a measure.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
is this what you want?
Column = MAXX(FILTER('Table (3)',year('Table (3)'[Date])=year(EARLIER('Table (3)'[Date]))-1&&QUARTER('Table (3)'[Date])=4),'Table (3)'[Closing SE])
Proud to be a Super User!
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |