Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi, experts, I want to get the gap of the relevant value, for example, the "cal" column in the picture, do you have any solutions?
Solved! Go to Solution.
VAR PreviousRow = CALCULATE( [Orders], OFFSET( -1, ALLSELECTED('Product'[yearmonth]), ORDERBY('Product'[yearmonth], ASC) ) )
RETURN [# Orders] - PreviousRow
Hello @Anonymous ,
I hope this helpful for you if not so can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
VAR PreviousRow = CALCULATE( [Orders], OFFSET( -1, ALLSELECTED('Product'[yearmonth]), ORDERBY('Product'[yearmonth], ASC) ) )
RETURN [# Orders] - PreviousRow
Hello @Anonymous ,
I hope this helpful for you if not so can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi,
What is the [Order] in the above function?
Hi,
thank you for your quick reply.
What is in [Order] measure?
Can you please elaborate on the total function?
Thanks, I am not quiet understand [# Orders] of "RETURN [# Orders] " , can you tell me what it stands for? Thanks.
User | Count |
---|---|
145 | |
73 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |