Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
HI, I calculated the Previous Month Average and then a divide by the number of rows. My DAX look like this:
Solved! Go to Solution.
Hi @SQUILES ,
It seems the count of previous month in your data is 0, thus the numerator/0=infinity. Please upload your dummy pbix to Onedrive/sharepoint/dropbix, and share us the link. that would be easier for us to provide the valuable advice.
Best regards,
Dina Ye
Hi @SQUILES ,
It seems the count of previous month in your data is 0, thus the numerator/0=infinity. Please upload your dummy pbix to Onedrive/sharepoint/dropbix, and share us the link. that would be easier for us to provide the valuable advice.
Best regards,
Dina Ye
trying using the divide function instead and see if that helps
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |