Forum Discussion
Anonymous
8 years agoNot applicable
Tableau Calculation into Power BI DAX Help
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.
1 Reply
- v-yuta-msft
Community Support
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