Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Vinu Hari]

Hi Members

I need help in fixing the below issues

1) The country, city output (Matrix table on the left) show only for Heathrow for period to date (PTD) and not showing the period to date budget (PTD_BUD). Same for other country, city pair as well.
2) The empty not to be shown e.g. 3P meal, bus etc, since there is no data available
3) The KPI light to be populated based on variance – above budget is red, else green
4) The top right corner, there is a PTD & YTD, this button is used to invoke PTD & YTD figure in matrix table

Hope this is doable.

Best regards

——————————
Srikanth Hari
FA
——————————

[Lutz Bendlin]

PTD_BUD (Foreigncurrencybudget = DIVIDE([PTD_Budlocal currency],SELECTEDVALUE('Bud BKPR 1920'[Rate]))?

nothing is selected for the rate.

Your data model might also need to be re-evaluated.

——————————
Lutz
——————————
——————————————-

[Vinu Hari]

Hi, The budget uses a single rate throughout the year, it just divide budget currency amount by fixed exchange rate set at the beginning of the year.

I have done some relationship changes, but as usual it is the PTD and BUD is working only for LHR and not for others

Attaching the file.

——————————
Srikanth Hari
FA
——————————
——————————————-