Forum Discussion
Create a virtual table based on date and other slicer selection
I need to create a virtual table which will be a subset of fact table based on slicer selection and calendar date selection. Please help.
tamerj1
Community Champion
Community ChampionAnonymous
Just creat a measure
Amount = SUM ( Tansactions[Sales] )
insert a matrix visual, placr Customers in the rows and the Amount measure in the values
No this will not help. Dynamically select the date from slicer and get the subset of transaction table.
- tamerj1
Anonymous
this is exactly what Powe Bi does. Why do you think you won't get the required result? Am I missing something?