topic Excel to DAX Translation and like 30 new Quick Measures in Gallery in DAX Commands and Tips

Excel to DAX Translation and like 30 new Quick Measures in Gallery

Greg_Deckler — Mon, 04 May 2020 12:59:47 GMT

So late last week, I started a community project in the Community Blog to try to create or catalog as many DAX solutions for Excel macro functions as possible. That project here:

https://community.powerbi.com/t5/Community-Blog/Excel-to-DAX-Translation/ba-p/1060991

And I think I kind of went a little crazy this weekend and created like 30 new quick measures to fill in some of the gaps:

https://community.powerbi.com/t5/Quick-Measures-Gallery/bd-p/QuickMeasuresGallery?sortby=postdate

Still working on this and still a long way to go! Currently working through all of the complex number functions!

Re: Excel to DAX Translation and like 30 new Quick Measures in Gallery

v-diye-msft — Thu, 07 May 2020 05:42:58 GMT

Hi Greg_Deckler

Thanks so much for your hard work!! The solutions you provided will be much helpful to our users!!

Re: Excel to DAX Translation and like 30 new Quick Measures in Gallery

Greg_Deckler — Thu, 07 May 2020 06:00:18 GMT

Thanks, up to 43 new gallery entries in the quick measures gallery. Trying to fill in as many gaps as possible! Have definitely learned a few things along the way! TRIMMEAN was probably the trickiest but my favorite is IMSQRT because I laugh every time I say it.