Forum Discussion

JConnol4's avatar
JConnol4
Frequent Visitor
7 years ago

IF Formula sum

Dear colleagues,   I am trying to do something which is straight forward (SAP user) but it is not allowing me in PBI and I would appreciate the help here please:   I am counting hot-spots when th...
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi JConnol4,

 

I recreated another new file using the older version of Power BI desktop. Please try to open it again. And for the functionCALENDARAUTO, you can refer to the oneline document.

 

Please notice here we need create relationship between dimtime and the fact table based on the date column.

 

Regards,

Frank

JConnol4's avatar
JConnol4
Frequent Visitor
7 years ago

Hi Frank

 

Thanks for all the effort and sorry for my nagging today.

 

i did everything you noted and it is still not working. I believe this is due to the relationships as you specified 1-1 in both directions, but the issue is that i have multiple incidents on the same day, therefore multiple same dates so it isn't working.

 

I amended your IF2 version so that two of the incident counts were on the same day and it failed.

 

Is there a solution to this issue at all please?

 

many thanks and regards

 

james