Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Categorising and Counting Within a Dynamic Time Period

Hello,    I have a table similar to the following: Person ID Form Date Form ID Form Name 123 01/01/2024 101 Missing Episode 345 02/02/2024 101 Missing Episode 567 03/03/2024 ...
Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous,
    Thanks for reaching out to the Microsoft fabric community forum.

    I've replicated the DAX measures on my end and generated the desired output. I've uploaded the .pbix file please take a look and let me know if it aligns with your requirements.

     

    Additionally, the third DAX measure returns a division result, which does not represent the percentage value. To display it correctly as a percentage, go to the visual's formatting options, navigate to Data format, and change the format from General to Percentage. This will ensure the value is presented with the % symbol for better readability.

     

     

     


    If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
    Thanks and Regards

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Thanks and regards