Forum Discussion

croufspesi's avatar
croufspesi
Frequent Visitor
7 years ago
Solved

Identify specific cell value based on row context and date

I've got a scenario where I can tell I'm close...but not quite there.  Tried combinations of things with FILTER, RELATED, and EARLIER but have not been successful.  Looking to identify the following:...
croufspesi's avatar
croufspesi
Frequent Visitor
7 years ago

Thanks Anonymous   I appreciate your help on this

 

I'm relatively new to trying this level of data modeling.  I've taken about 15 hours of online courses through Udemy on DAX/PowerBI, so DAX is just what I'm familiar with because of that course.

 

I can see that in PowerBI M is used... but wasn't sure if as a beginner, I should already be diving into another language and forgetting the one I just recently learned.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Why should you forget DAX while learning M? M is a data mash-up language, whereas DAX is Data Analysis eXpressions language. They serve very different purposes. In addition, you don't have to know M at all to use Power Query. Of course, it's always better to know what's going on under the hood but it's not strictly necessary.

     

    Best

    Darek