How to write below formula in powerbi(its in sap bo webi formula)

[Harish85]

[Budget amount]Where(([Fiscal Period]="1") And ([Fiscal_Year_Filter] = [v_Fiscal_Year]))

[ThomasWeppler · Accepted solution]

Measure name =
CALCULATE (
[Budget amount],
[Fiscal Period] = 1
&& [Fiscal_Year_Filter] = [v_Fiscal_Year]
)

I hope this solves your problem 🙂

[PijushRoy · Accepted solution]

Hi @Harish85 

Please try and let me know if below formula works for you in a measure

Budget Amount Measure = 
VAR SelectedFiscalYear = SELECTEDVALUE('YourTable'[Fiscal_Year])
RETURN
CALCULATE(
    SUM('YourTable'[Budget Amount]), 
    'YourTable'[Fiscal Period] = "1", 
    'YourTable'[Fiscal_Year Filter] = SelectedFiscalYear
)

or

Budget Amount Measure = 
VAR SelectedFiscalYear = SELECTEDVALUE('YourTable'[Fiscal_Year])
RETURN
CALCULATE(
    SUM('YourTable'[Budget Amount]), 
    'YourTable'[Fiscal Period] = 1, 
    'YourTable'[Fiscal_Year Filter] = SelectedFiscalYear
)

[Kedar_Pande · Accepted solution]

@Harish85 

Budget Amount Filtered = 
CALCULATE(
SUM('YourTable'[Budget amount]), 
'YourTable'[Fiscal Period] = "1", 
'YourTable'[Fiscal_Year_Filter] = [v_Fiscal_Year]
)

Replace 'YourTable' with the actual table name in your Power BI dataset

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[Harish85]

Hi Can you please check this formula in powerbi

FISCAL_YEAR_FILTER= CASE WHEN (substr(current_date,6,2)) IN ( '01','02','03') THEN (substr(current_date,1,4)-1) ELSE (substr(current_date,1,4)) END

[PijushRoy · Accepted solution]

Hi @Harish85 

Please try and let me know if below formula works for you in a measure

Budget Amount Measure = 
VAR SelectedFiscalYear = SELECTEDVALUE('YourTable'[Fiscal_Year])
RETURN
CALCULATE(
    SUM('YourTable'[Budget Amount]), 
    'YourTable'[Fiscal Period] = "1", 
    'YourTable'[Fiscal_Year Filter] = SelectedFiscalYear
)

or

Budget Amount Measure = 
VAR SelectedFiscalYear = SELECTEDVALUE('YourTable'[Fiscal_Year])
RETURN
CALCULATE(
    SUM('YourTable'[Budget Amount]), 
    'YourTable'[Fiscal Period] = 1, 
    'YourTable'[Fiscal_Year Filter] = SelectedFiscalYear
)

[ThomasWeppler · Accepted solution]

Measure name =
CALCULATE (
[Budget amount],
[Fiscal Period] = 1
&& [Fiscal_Year_Filter] = [v_Fiscal_Year]
)

I hope this solves your problem 🙂

[danextian]

hI @Harish85 ,

Assuming that Budget Amount, Fiscal Period and v_Fiscal_Year are all coumns, try this as a measure:

CALCULATE(
    SUM ( 'Table'[Budget amount] ),
    'Table'[Fiscal Period] = "1",
    'Table'[Fiscal_Year_Filter] = 'Table'[v_Fiscal_Year]
)

Assuming Budget Amount is an external measure, you can just reference it.

CALCULATE(
     Budget amount],
    'Table'[Fiscal Period] = "1",
    'Table'[Fiscal_Year_Filter] = 'Table'[v_Fiscal_Year]
)

Please note that "1" is a text and so Fiscal Period column must also be a text data type.