Forum Discussion

ryan_smith_ww's avatar
ryan_smith_ww
Frequent Visitor
5 years ago
Solved

DAX in 1st table for data in the third table. (SQL query given. Looking for Equivalent DAX)

Hi,   I've got three tables in PowerBI TableA, TableB and TableC. Relationship is one-to-many in the order TableA --> TableB --> TableC. I want to have a measure in tableA that will use rows of Ta...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    with the relationship, just simply use RELATEDTABLE to get rows of TableC

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

ryan_smith_ww , TableA, TableB, and TableC should in power bi on keys.

 

You need to have date tables. 2 are needed here. One joined with periodstartdate of Table3

 

refer this video, how you can get two-period filters 

How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg

  • ryan_smith_ww's avatar
    ryan_smith_ww
    Frequent Visitor
    5 years ago

    Thanks amitchandak . TableA, TableB and TableC are in PowerBI with relationships defined between them. Unfortunately I'm still not clear on how do I convert the SQL shared above to equivalent DAX for the measure.

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      5 years ago

      ryan_smith_ww , Please share relationship digram, based on that I suggest

      • ryan_smith_ww's avatar
        ryan_smith_ww
        Frequent Visitor
        5 years ago

        amitchandak Here's the basic diagram for the Three tables. Thanks for your help.