Forum Discussion

FlankyPank2___'s avatar
FlankyPank2___
Icon for Helper I rankHelper I
1 year ago
Solved

Creating a relationship on my daily occupancy chart

Hi   I've produced a chart plotting daily occupancy (From wonderful support on here!).   The info comes from a spreadsheet called "Data" in a format like:   ID Number    Name                 Pr...
Need Help
  • FlankyPank2___'s avatar
    FlankyPank2___
    1 year ago

    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

     https://youtu.be/O653vwLTUzM

    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 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, FlankyPank2___ 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

 

Best Regards

Yongkang Hua

FlankyPank2___'s avatar
FlankyPank2___
Icon for Helper I rankHelper I
1 year ago

Hi This problem wasnt' solved unfortuanately - I've tried to alter my Total Value Dax but i cna't see the wood for the trees.  I don't know if anyone can shed any light?

 

It's a disconnected table so I know that's where the challenge lies - Thanks