Forum Discussion

Nimai123's avatar
Nimai123
Icon for Post Patron rankPost Patron
6 years ago

Excel to DAX

I have a formula in excel which is calculating the percentage only if it has data for above 4 qtr   How can I convert this in a DAX expression using this logic of the formula   Reference image 1 ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

You're killing me Nimai123 

 

So for the sample data that you posted, the first two are columns in the left table in your image and the last one is a column in your date table or ? 

 

Please follow the instructions here: Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Sample data as text in the same form that it appears in your data. Expected result from sample data. Logic of how to get from a to b.

Nimai123's avatar
Nimai123
Icon for Post Patron rankPost Patron
6 years ago

I have sent you the link for the file to download in Private Message. 

 

Thanks for your patience!

 

Regards,

 

Greg_Deckler