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 All,
I've inherited a relational database with c.750k lines of data and I'm trying to build something to show billings by month and the cumulative total as a percentage of the target.
Annoyingly the target is a yearly rather than a monthly one, and is built into the billings column but can be identified by target being present in another column.
I've made measures with the billings, cumulative billings and target, and I can see that the maths is right in the totals but I'm getting zero in my months. Anyone have any ideas?
I also tried a sumx for my VAR but that was giving me target billings of c.12b instead of 4.2m, I'm guessing as it was summing across rows?
Thanks,
EMTHB
Hi @EMTHB ,
I can not help you very well. Maybe you can provide me with your pbix file?
Please remove sensitive data and do not log in to your account in Power BI Desktop when uploading pbix files.
All this is to better solve your problems.
I would be grateful if you get back to me quickly.
Best Regards,
Clara Gong
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |