Forum Discussion

hamburgernic's avatar
hamburgernic
New Member
1 year ago
Solved

using a measure as a y axis

Hi,   I am looking to use a measure (number of months) as a y axis but am unable to do so   context example: I have a few book loan records that are already due to be returned. I want to track o...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    hI hamburgernic 

    If you're going to compare the due date with the current date, a simple DATEDIFF calculated column against today's date should be enough

    Months Due = 
DATEDIFF ( 'Table'[Due Date], TODAY(), MONTH )

    However, if you want to determine how many months a book loan is due based on a date selected in a slicer — and expect the numbers in the visual to change accordingly — this approach will not work. Calculated columns are not responsive to slicer selections and will not adjust their values dynamically. That said, based on your description, the calculated column provided above should still meet your needs.

v-karpurapud's avatar
v-karpurapud
Community Support
1 year ago

Hi hamburgernic 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.