Forum Discussion

rodrigo_avf's avatar
rodrigo_avf
Frequent Visitor
3 years ago

Recontact count using DAX

Hi, hope someone can help me with this. I have a 2 columns table with Date and Tickets count. I need to add a new column using DAX (can also be a measure instead) that will give me the recontact co...
Need Help
barritown's avatar
barritown
Solution Sage
3 years ago

Hi rodrigo_avf,

I see. My approach apparently doesn't fit. I tried a couple of other ideas today, but they didn't work either. Should I solve it via some programming language, I'd get rid of the odd dates in a series of cycles first and then perform the calculation for the rest, but that's not about [DAX].

Hope someone from Community solves your problem, I'll be happy to watch and learn.

Should I get an "Evrika!" insight, I'll get back to you.

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

rodrigo_avf's avatar
rodrigo_avf
Frequent Visitor
3 years ago

Thanks for trying barritown 
The workaround I did was to get the range of dates each date falls in using Excel, wich is super easy to do, but as my data has more than 300k rows and growing, I had to split it into different Excel files because the formula is a bit heavy.
After that I import everything to Power BI and finish the calculations there.

But still would be really nice to learn how to solve this using DAX and/or M only, it would also make things simpler.