How to get the current date wise Target dynamically change daily.

[hb0135]

Hello,
I have datewise plan(Target) in excel shown as below , i want change that plan dynamically in power bi card without doing that manually everyday by going filters option and same with actual Qty to be change dynamically

Please give solution for above need help,
Regards & Thanks,
Hb0135

[amitchandak · Accepted solution]

@hb0135 , one is you can use relative date slicer on the page.

Make sure all your tables are joined with the date table and the Date table is used in the slicer

Second if you filter date in slicer, if should simply filter value based on selection

sum(Table[Value])

Above measure should respond to slicer

Or create a measure based on today

Today = CALCULATE(sum(Table[Value]) , FILTER('Date','Date'[Date] = Today() ) )

or

Today = CALCULATE(sum(Table[Value]) , FILTER(all('Date'),'Date'[Date] = Today() ) )

[hb0135]

Hello,
Thanks for help it work
BR,
HB0135