Forum Discussion
Helper ICreating a relationship on my daily occupancy chart
Thank you for the reply.
I'm just trying to track/count daily building residency. Swapping between certain critera. Using an active spreadsheet that uses a start & end date.
I followed a youtube tutorial
which gave me the total Value measure - i'll return to it and check. Although at the time I double checked against an excel version I have and it seemed to match.
I tried modifying the Total Value measure initially, but failed!
I think i need to concentrate on learning more dax instead of winging it lol.
Thanks
Community ChampionGot the pbix, thanks.
You are using a disconnected date table so that you can use Fact data between the start date and end date.
The card won't respond to changes in the date slicer because there is no relationship between the 2 tables.
You'll need to write a measure similar to the Total Value measure for this
---
However, are you happy with the Total Value measure? To me (and I don't know your business requirements) the date comparisons don't look correct.
max('Date23-24'[Date]) is the max value from the date slicer. You don't seem to be using the min value at all.
Helper IThank you for the reply.
I'm just trying to track/count daily building residency. Swapping between certain critera. Using an active spreadsheet that uses a start & end date.
I followed a youtube tutorial
which gave me the total Value measure - i'll return to it and check. Although at the time I double checked against an excel version I have and it seemed to match.
I tried modifying the Total Value measure initially, but failed!
I think i need to concentrate on learning more dax instead of winging it lol.
Thanks