I have a dataset in power BI that has the period, year, client identifier and debtors balance over a period of years for multiple clients.
I'm wanting to find out the current year and the latest period. For example, in the financial year starting in April 2022, in August of that year it will be 2023 for the current year and period 5 for the current month. I then want to use this information to calculate further fields.
I have created a measure to calculate the max on the year (the current year) which returns 2023, called 'Fees Balances'[Current Year]
I then wanted to use that to find the max period (the current period) on the periods with the year 2023, therefore I set up a measure:
Current Period = calculate(max('Fees Balances'[Period]),'Fees Balances'[Year]='Fees Balances'[Current Year])
but it's giving me the error message, "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."
If I swapped in 2023 manually:
Current Period = calculate(max('Fees Balances'[Period]),'Fees Balances'[Year]=2023)
It worked, but the year will change, so wanted it to calculate it dynamically.
Thank you for your help
Best wishes
Ros
