This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
What formula should I use to see the completion rate of the month I selected from the Date Slicer in the relevant report?
For example, when I select April, it will perform the operation of today/last day of the month. (4/30=%13)
When I select March, it will be 31/31=%100 because March has ended.
When I select January-February-March-April, it will give the result of (31+28+31+4/31+28+31+30=%0.78).
I kindly request your support.
Thank you.
Solved! Go to Solution.
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rhn-1vTMxIImA6R7R?e=Nv7mVY
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rhn-1vTMxIImA6R7R?e=Nv7mVY
Thank you very much
month names
Slicer with date information
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 35 | |
| 27 | |
| 26 | |
| 22 | |
| 18 |
| User | Count |
|---|---|
| 66 | |
| 36 | |
| 32 | |
| 26 | |
| 23 |