Forum Discussion

kvitnitskiy's avatar
kvitnitskiy
Frequent Visitor
6 years ago

Column Slicer

Hello All,  I have source table like below,  I would have  slicer  Appt_date, Check_In_Date, check_Out_Date   which will  show me data in the same tale based on selected value.  like  here c...
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Recursive calculations are possible with List.Accumulate in query, but it is tricky to use and it probably isn't very performant on large datasets (but I haven't tried).  However, I agree it is much better to make a model that doesn't need it.

 

Regards,

Pat

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

mahoneypat, I'm talking about DAX, not about M. In M you can do anything. It's a fully-featured functional language.

 

Best

D