Forum Discussion
SQL OUTER APPLY - DAX equivalent?
also there is this guided learning to help you get going
i will review the articles and thanks for the guidance. I think you are saying to use power query for broad sweeps at shaping the data. Perhaps that is what i need to think about as well. At any rate I will review and come back with DDL with actual SQL if I don't make headway.
I read the material links. Doesn't look like OUTER APPLY is supported....worried.
Would you mind looking at the problem in http://community.powerbi.com/t5/Developer/DAX-equiv-needed-Historical-Trending-of-application-outages/m-p/187356
different issue but with same dataset is here:
http://community.powerbi.com/t5/Desktop/Need-date-sorting-on-bar-graph/m-p/187584#M82502
Can I do this historical trending with DAX? Is there an alternative to OUTER APPLY? Or just forget SQL, can this be done in DAX?