Forum Discussion

aflip's avatar
aflip
Frequent Visitor
3 years ago
Solved

Need to create measure that compares between the selected date and the prior month

My dataset looks like this: (Showing only Lease_Number = 1. There are thousands of Lease_Numbers in the dataset)   I have a slicer vertical list of all the Accrual_Period_Dates:   I n...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

aflip's avatar
aflip
Frequent Visitor
3 years ago

Thank you so much!

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

You are welcome.

  • aflip's avatar
    aflip
    Frequent Visitor
    3 years ago

    Hello Ashish,

    I really like how clean and simple the solution you provided was. However, I'm having EXTREME difficulty using the measure as a filter on a bar chart. It isn't producing any results...The table works great, but for some reason the bar chart doesn't like the filter: MEASURE = "New Payment". The bar chart I'm trying to create is just a clustered column chart with [Amount_Current} vs. date(not accrual_period_date....the other date).

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      3 years ago

      Hi,

      Share the download link of the PBI file.  Clearly show the problem there and also the expected result.