Forum Discussion

DocDri's avatar
DocDri
Icon for Helper I rankHelper I
1 year ago

Use last available data in line chart

Hello, maybe you can help me with another problem:   I have a table with project data (values) for different reporting periods like this   project | period | valueX | value Y A | 2025.01 | 15 |...
Need Help
DocDri's avatar
DocDri
Icon for Helper I rankHelper I
1 year ago

Hi! Thank you very much for your hint. One question: Does this measure really returns the last available value? For me it seems that it returns the biggest value (  MAX('Projects'[ValueX]) ) where 'Projects'[Period] <= CurrentPeriod. That must not be the latest, or am I wrong?

DocDri's avatar
DocDri
Icon for Helper I rankHelper I
1 year ago

DataNinja777 am I right or do I miss something in my thoughts? Thanks for a short reply