Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Capturing a date from a calculated table

I am looking to take the date that forecasted points intercept the estimated points to show in a card. The DAX I wrote produces an error because I am asking it to filter a calculated table, so it "doesn't have any columns." 

Is there a way to work around this?

This entire table is built off of other measures.

 

I am willing to share more information if this is not enough. Thank you.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous,

    AFAIK, current power bi does not support creating dynamic calculated columns/tables based on filter selections. They work on different levels and you can't use the child to affect its parent.

    For your scenario, I'd like to suggest you create a measure expression and add a variable to summarize table records, then you can use this table to calculate on particular row context and filter.
    After these steps, you only need to use an aggregate function to aggregate table records to return a single result.

    Notice: the data level of power bi(from parent to child level)

    Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

    Regards,

    Xiaoxin Sheng