Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I work for a housing charity. The data is confidential, so it's a bit difficult for me to post examples.
We do a monthly property check (known as an MPR) and I need to show whether a report has not been done in the previous month.
We have a number of properties across the country looked after by different centres. There is a one to many replationship between each of Centres->Properties->Questionnaires.
I can easily create a matrix with Centre/Property/Lastest MPR Date using this Measure:
HI @Anonymous ,
Create some sample data and share explaining issue. It's not very clear from your description.
Thanks,
Pragati
OK, I'll try to explain:
We have Centres:
Centre 1
Centre 2
Centre 3
Centre 4
We have Houses:
House 1 in Centre 1
House 2 in Centre 1
House 3 in Centre 2
House 4 in Centre 2
House 5 in Centre 3
etc
Joined by Centre Code on a one-to-many relationship
Each House has a number of Questionnaire records with the date of the last inspection:
House 1 01/04/20
House 1 02/05/20
House 2 03/04/20
House 2 05/06/20
House 3 <no report done so no questionnaire record>
Joined by House Code on a one to many relationship
I can get the last house check done date with this measure:
Hi @Anonymous
You might consider providing your dummy pbix that would be helpful for us to investigate it further.
You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.
@Anonymous - Not really all that clear. What is your [First Day of PrevMonth] calculation?
Yes, sorry.
It's a measure:
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |