sap bo to powerbi

[Harish85]

I want to create variable in Powerbi, below is the sap bo formula.

Please help me.

Fisical_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

[v-mengmli-msft · Accepted solution]

Hi @Harish85 ,

What is the result of your current formula? Also, what are your expected results? I was hoping you could provide an example.

In general, in DAX we use the If as the judgment statement and the MID to extract the substring. You can try below formula firstly.

Measure = IF(MID(MAX('Table'[DATE]),6,2) IN {"01","02","03"}, MID(MAX('Table'[DATE]),1,4)-1,MID(MAX('Table'[DATE]),1,4))

Best regards,

Mengmeng Li

[ThomasWeppler]

I you want to write that in Dax try something like this 
Fisical_year_filter= if(substr(current_date,6,2) in {01,02,03}, date(year(today),month(1), day(1))-1, date(year(today),month(1), day(1))

I am not sure I got everything right, but a good place to start would be to look of power BI

If function

In function
datediff function.

I think that would get you in the direction of a good solution.

[Harish85]

when I am trying to create above given formula substring is not coming up, can you help me in that.

[ThomasWeppler]

Is sustring a value in a table? If so:
First write selectedvalue( and then write substring.