FF: Distribution-of-days-per-month-between-two-dates/m-p/854874

[Anonymous]

Hello PBI Community,

Following my previous post regarding the distribution of days per month (link below), I have now applied the same technique to my own dataset. However, I can't seem to get PowerBI to display the correct that I'm after. When I use [RefID], the data displays fine, but if I use HotelName as a row, which is the one I'm after, no data shows. Could anyone walk me in the right direction, please? 

Another thing. Is it possible to apply multiple filters per row? Say for example, for Hotel A, I only want the data from a certain period, and hotel B from a different period too? I hope that makes sense. Thanks

Occupancy.pbix 

https://community.powerbi.com/t5/Desktop/Distribution-of-days-per-month-between-two-dates/m-p/854874

[Anonymous]

Just want to bump this thread hoping to get a solution to my problem as I still haven't found a solution. Appreciate any help. Thanks all!

[v-juanli-msft]

Hi @Anonymous 

Sorry, i can't find a solution for your problem,

if you are anxious, please post a new one with link to this one, then more replies you may receive.

You could also share me the link, i can make the new one as a bump case.

Best Regards
Maggie

[v-juanli-msft]

Hi @Anonymous 

From your table, the same "HotelName" with many rows of different "ResDate", "InDate", "OutDate",

Your measure can't recongize which date to use.

If i change the measure with "min" function, i can get such result.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

hi @v-juanli-msft ,

I tried that as well, but unfortunately, it will only return the data of 1 entry which is the ealiest InDate instead of the total for the entire hotel.