Row level formula in salesfore not showing in power IB

[swaroopkumarmg]

Hello There,

I have created a report in Salesforce and have added a new column 'Year' (Row level formula)

i have put some filters too- Delivery type and Year.

In salesforce i see all the columns and the filter works just fine. When i import this data to Power BI, i do not see the 'Year' Column but the report in power BI show's only the data the i have filted based on Delivery type but not based on the Year.

Ex on Sales force:

Actual data 

SNo  Delivery Type  Year

1.        Air                  2019

2.        Air                  2020

3.        Land               2020

4.        Sea                 2020

5.        Air                  2020

6.        Air                  2020

Report with Filters- Deliver type = Air ; Year = 2020

SNo  Delivery Type  Year

1        Air                  2020 

2       Air                  2020

3       AIr                  2020

Same table in Power BI 

SNo  Delivery Type  Year

1        Air                  2019

2       Air                  2020

3       AIr                  2020

4       Air                  2020

Is this happening because i added a new column 'Year'?

Please let me know.

[v-chuncz-msft · Accepted solution]

@swaroopkumarmg 

Check code that Query Editor is creating with each step in The Advanced Editor. Alternately, you may add calculated columns in DAX.