Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all
Hope i find you well 🙂
I have a problem that i cant solve and asking for help.
I need to return a sum count of how many times the word 'Passed' in my [outcome] column shows in between todays date and todays date -730.
It probably is a very simple solution but i can't seem to get it 😞
thank you in advance for any help recieved 🙂
Gary
Solved! Go to Solution.
Hi,
Here is an example of the logic to use:
Proud to be a Super User!
@ValtteriN
Thank you.
I found a youtube video explaining using a calendar model.
Once i did this it worked.
I have marked this as the solution
now i have to find how to return just the latest records from the table as there are duplicates in there 😞
For anyone who wants know how to create a calendar model this video explains it perfectly 🙂
https://www.youtube.com/watch?v=z8hgSFQOPSM
Hi,
Here is an example of the logic to use:
Proud to be a Super User!
@ValtteriN
thank you for replying.
Im new to this and im picking up somebody elses work 😞 (i normal work with Powerapps and Automate)
No doubt i have it completely wrong as it doesnt work when i place my column names in there 😞
My columns are
Table = 'BA1 Hot wear'
date Column = 'BA1 Hot wear'[Date of Assessment]
Text column = 'BA1 Hot wear'[Assessment Outcome]
So i have this but with questions.
Is the 'Calendar example'[Date] = 'BA1 Hot wear'[Date of Assessment]
Thanks
Gary
I made the assumtion on my last message that it was the column as asked but i get this message.
Hi,
It is generally a good idea to have a calendar table in your data model. The column I am referring to is an example of this.
Proud to be a Super User!
User | Count |
---|---|
40 | |
26 | |
22 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |