Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello I have created teh following mesure to illustrate cummulative values. However, I simply get the value of each month. Any ideas what is wrong with the measure? Thanks!
Solved! Go to Solution.
Hi @Anonymous,
I have noticed you have used a calender table and I have tested with my sample data, it could work on my side:
I wonder if you have created a relationship with your fiscal table and your calender table? when I deleted the relationship, I could reproduce your problem, so I suggest you to check if you have created the relationship and also download my pbix file to have a view.
Regards,
Daniel He
Hi @Anonymous,
I have noticed you have used a calender table and I have tested with my sample data, it could work on my side:
I wonder if you have created a relationship with your fiscal table and your calender table? when I deleted the relationship, I could reproduce your problem, so I suggest you to check if you have created the relationship and also download my pbix file to have a view.
Regards,
Daniel He
Hello,
indeed the issue was with the Date Dimension relationship. I have a relationship not in the Date attribute but in the DateSK which is e.g., 20180101 in any case I reinserted the Date Dimension and created a relationship between the Date columns. This solved the issue. Thanks for the hint!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |