How to convert measure From Tableau to Power BI using DAX

[Anonymous]

Hi there, 

i am new on dax and i have been trying to convert measure Tableau to Power BI but it give me wrong numbers. now i need help for How to convert measure From Tableau to Power BI using DAX?

{ FIXED [Asset Class ID] , [Month],[Year] : MAX([Actual])}

thanks 🙂 

[AlB]

Hi @Anonymous 

Can you explain what the measure actually does (for those not familiar with Tableau and please show a sample of your data tables?)

Please always show your sample data in text-tabular format in addition to (or instead of) the screen captures. A screen cap doesn't allow people to readily copy the data and run a quick test and thus decreases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here. Or, ideally, share the pbix (beware of confidential data).

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[Anonymous]

Hi @AlB 

I am working on variance to find a AGG range value as you can see the below screenshot 

I want to use same tools in power bi. 

thank you