Community Center | Not monitored
Tag not monitored by Microsoft.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I would need people help me in power bi. I need to create new column based on table below to compute "Total participants"; if firstvalue will compute the same "Total participaint" group by health facility; but if MAX will compute "Total participants" of MAX minus "Total participants" of firstvalue group by health facility.
]2
The result would be below:

Thanks!
Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
https://community.powerbi.com/
--please don't forget to upvote and Accept as answer if the reply is helpful--