calculating Normalisation % for 4 latest quarters

Hi,

I have trouble with dynamically calculating this formula for 4 latest quarters

Norm Alkathene = [LPI Alkathene]*100/[Alkathene L5]

[LPI Alkathene] - A calculation of count of tickets.

[Alkathene L5] - Count of last 5 years of tickets.

I have also attached the new "QnC Updated.pbix" file which contains this table for all materials.

The trouble I am having with my calculation measure is,

1. When I apply date filter, the values that are coming are different.

2. I want the last 5 years count to stay constant for the year, i.e., it should be 219 even when I drill down to 2023 Quarters for Norm calculations.

Message 1 of 1

231 Views

0 REPLIES 0

Helpful resources

Announcements

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

Find out what content was popular in the Fabric community during 2024.