Tableau Calculation into Power BI DAX Help

[Anonymous]

Hi

Below is the calculation created in tableau : Preety simple in Tableau.

IFNULL((IFNULL([Sum Sold Last By Branch Dealer Model],0)*1.0/IFNULL([Sum Sold Last 2 Years By Main Dealer Model],0)),0)

Can anyone help me to write it in Power BI dax, as i am new to it. 

Thanks.

[v-yuta-msft]

Hi maheshrakwal,

You can ISBLANK() and IF() to achieve this in power bi, for more details about dax, please refer to: https://msdn.microsoft.com/en-us/query-bi/dax/data-analysis-expressions-dax-reference.

Regards,

Jimmy Tao