Forum Discussion
Computing values between a range of dates
Hey there Here's the link for my sample file. How can I compute the amount of sales for a given user, but respecting their active date period? For instance, taking the IdUser = 1 into consider...
Hi,
Darag this measure to the visual
Modelo1 = SUMX(VALUES(d_calendar[Week]),[Modelo])Hope this helps.
Hey, Ashish_Mathur . Thanks for your response.
Great, it has actually worked.
Do you know how to compute the second part?
The other calculation I'd like to compute is basically the same, however now the date period is stored at f_users. In this calculation, only the IdSale = 16 should not be take into consideration as the IdSale = 19 took place in his second active period at f_users.
My real-life model has this particularity, but I don't know how to solve this either.
Once again, thanks for your response.
I just cannot understand your requirement. Share a simple dataset and show the expected result.