Forum Discussion
Helper IVDynamic measure selection
Hi, Mous007 , no worries, I come to your rescue, with the LEGEND of line graph 😂
I presume your data is more or less like this,
The measure can be simplified to
Total Overdue = SUM( Consolidated[Overdue] )You might want to refer to the attached file for more details.
Helper IVHi MattAllington , thank you for the prompt reply.
I am actually not trying to get the current month compared to previous month. But i would like to users to choose any month from the slicer (Jan to Dec) e.g. select July. Sep and Nov and show the corresponding values into the graph.
Apologies if my request isnt clear enough.
- amitchandak
Super User
Mous007 , In such a case you have two ways. Keep a snapshot of every month. Or rebuild based on logic when measure is called(Slicer values /date can help)
Dax append can help
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/Or you need to provide some logic to calculate. Can you share sample data and sample output in table format?
