Forum Discussion

pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
6 years ago

Filtered DateDIFF

Hi. I want to calculate measure which show a date difference between today and last transaction on particular item. But to this calculation I want to take only specified type of transactions (Trans...
pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
6 years ago

Anonymous 
Haha, so stupid mistake.
I didn't notice that I had only positive values ğŸ˜….

The last thing about this topic,
How to visualize this measure?

I want to make Pie chart with Aging as Legend and current index values as Values but because Agins is a measure, that means it can't be use this way.

Do you have any creative idea to show my results?

pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
6 years ago

Maybe should I use column instead of measures for whole calculation?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    pawelj795 not sure what is the index value  field in your dataset but you should create a calculated column for aging if you want to use that field as legend.