Acquisition rates for multiple markets' holiday schedule

[feliciapedwards]

Hey,

I'm currently trying to figure out an elegant way to break out acquisition rates by weekdays, weekends and holidays. I'm able to do it for one market at a time, but it's extremely messy. I create a column with specified holiday dates (ours are very specific, not something I can just pull off the web), and combine the weekday/weekend column with holidays, and break out the rates using that column. This is only for one market, that means I'd have to perform these exact steps for all the other markets I want to bring in. Does anyone know an elegant way for calculating holiday rates across multiple markets? 

Thanks in advance. 

[v-diye-msft]

Hi @feliciapedwards 

Do you have some sample data or preferably a sample pbix file.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490