Forum Discussion
Convert Tableau function WINDOW_SUM into DAX
Hello, I would like to convert the below Tableau expression into DAX: WINDOW_SUM(sum([values]), -DATEDIFF('day',DATE('1/4/'+str(year(DATEADD('month',-3,attr([Date]))))),attr([Date])),0)
Greg_Deckler The formula works as a cumulative total. There window element is not there.
Anonymous Right, the formula I provided is a cumulative total that resets on April 1st. There is a new WINDOW function in DAX. It's sort of kind of supposed to work at a "visual" level but that's not really how it works.
If you want a cumulative total that resets on April 1st, the formula I provided should work. It dynamically creates the "window" in the __Table VAR.