Forum Discussion

Silvard's avatar
Silvard
Icon for Resolver I rankResolver I
1 year ago

Iterate over two different columns/tables

Hi,   The below measure is mostly producing the correct result, but given SQLBI recommend not to create calculated columns within summarize and instead use addcolumns to do so, I'm looking for a be...
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, Silvard 

Based on your description, it's hard to figure out what you expect to achieve. You can share the pbix file without sensitive data and give your desired implementation.

Best Regards,
Yang
Community Support Team

Silvard's avatar
Silvard
Icon for Resolver I rankResolver I
1 year ago

Hi Anonymous 

 

Thank you for your response.

 

I would like to get the datedifference between two dates from different tables that are only "connected" via the facts table. The keys of their respective tables are not at the same granularity and as such can't be connected to each other.


The measure will be used in a line chart detailing time period and should respond accordingly.

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, Silvard 

    You can describe your needs with specific data, which can help realize your output faster.

    Best Regards,
    Yang
    Community Support Team