Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Creating a Measure to Compare Aggregated Values Across Different Date Filters

I'm working with two separate measures in Power BI, each calculating the sum of the same calculated column. However, each measure is filtered by a different date table to allow for time-based compari...
  • v-kpoloju-msft's avatar
    1 year ago

    Hi Anonymous,

    Thank you for reaching out to the Microsoft fabric community forum. Also thanks burakkaragoztharunkumarRTK,  for those valuable insights for this thread.

    After thoroughly reviewing the details you provided, I reproduced the scenario again, and it worked on my end. I used it as sample data and successfully implemented it.

    outcome:


    I am also including .pbix file for your better understanding, please have a look into it:

    If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

    Thank you for using Microsoft Community Forum.