@Gjakova bizzare, is datum column is date type when you selected Mark as date table , did you used datum as a column for a date? Can you share the screenshot of mastercalendar table with all the columns showing in field pane, datum icon should look different compare to others, which shows it is marked as a date.
I managed to solve it!
Hi there, it is already late on the other side of the world for screen sharing, but I appreciate the help!
Eventually your measure was correct, the only thing that was missing was a , before MONTH and before DAY.
Solution: ,DAY instead of DAY and ,MONTH instead of MONTH.
Maybe the Power BI settings are different in other regions of the world? Anyhow, thanks a lot for the measurement. Just one more question: why did I had to unipivot all the info except for ID, would it otherwise not have worked? (The thing you mentioned in your 2nd or 3rd post here).
Thanks a lot!
@Gjakova oh ok, not sure why but comma was always there. Anyhow glad it is working. We did unpivot so that with few measures we can work on all the fuel categories, otherwise, we need to write measures for each column (each category) and that would have been 3 categories x 3 columns = 9 measures and also it is not scalable, and best practice. You cannot even filter if you had 3 columns and now can easily filter. Not sure if this answered your question but if you have any further questions, I can gladly explain.
@parry2k here are some extra screenshots for a clarification of what I adjusted to make it work:
Kudos are welcome if it gave you some clarification 😛
Ah I did not know that! Thanks a lot. So it is better to have more rows than columns? Or is that just the case when you want to create measures?
@Gjakova basic rule:
facts on which you do the calculations, usually are long and thin
dimension by which you measure facts, can be wide
if it makes sense. Anyhow, that comma thing is bizarre for me but I'm going to sleep over it for now. We already spent a lot of time on it and I'm glad it is working for you. Cheers!!