Forum Discussion

soji's avatar
soji
Frequent Visitor
3 years ago
Solved

Using Loop in DAX

  I am struck in one of the process to get the worked location of each employee for each date as i am not sure how to use Loop in DAX. I have two tables as Worked location Table and Location Transf...
Need Help
Itsbibin's avatar
Itsbibin
Regular Visitor
2 years ago

Hi Ahmedx 

Ihave 2 table in my Power BI report B-Details and SPResult. SP result table is a stored procedure and will change dynamically with parameters. I want to create a new table from this in which it should filter Name and Country from B-Details and SPResult. Now after filtering this we have a uniquekey in B-Details. Now in the new table for each UniqueKey we have to get all the filtered values from SPResult table. So in the new table UniqueKey key row will be duplicated with as much rows we have in SPResult. Can you help me how to fix this?

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    create a new topic, show what you want to get, because it is not clear what you need