Forum Discussion
Helper IIIHow to get the current date wise Target dynamically change daily.
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
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() ) )
2 Replies
- amitchandak
Super User
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() ) )
hb0135Hello,
Thanks for help it work
BR,
HB0135