The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello ,
i searched everywhere. dut didnt find anything that could help.
what im trying to achieve can be seen in the the excpected column :
this calculate should be calculated as folow :
current row's fact - previous row's fact ( within each group ) .
so when you are on g2 - sg1 , it should return blank() and not 5 - 4 =1
is it possible using paginated report expressions ?
because, although you can use previous function. but i couldnt make it to be able to calculate the previous fact within each group .
sample data :
group | subgroup | fact | expected column |
g1 | sg1 | 1 | |
g1 | sg2 | 2 | 1 |
g1 | sg3 | 3 | 1 |
g1 | sg4 | 4 | 1 |
g2 | sg1 | 5 | |
g2 | sg2 | 6 | 1 |
g2 | sg3 | 7 | 1 |
g2 | sg4 | 8 | 1 |
Solved! Go to Solution.
Hi @Daniel29195 ,
Below is my table:
The following Expression might work for you:
=IIf(Fields!subgroup.Value = "sg1" , " " , Fields!fact.Value - Previous(Fields!fact.Value))
The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Daniel29195 ,
Below is my table:
The following Expression might work for you:
=IIf(Fields!subgroup.Value = "sg1" , " " , Fields!fact.Value - Previous(Fields!fact.Value))
The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.