But it doesn't work as expected. For now, I am using an Import mode, but I need the final solution for Direct Query mode. So my calculation mentioned above won't also work in direct query. Please let me know if any other information required. Could you please help me on this? Thank you in advance!
Hi @v-piga-msft , Thank you very much for your response. I appreciate your help. Unfortunately, it doesn't work for me as my data for Over/Under Reported time column is presented as a daily period (probably I forgot to mention that). And then I use a measure to sum Over/Under Reported time by month using this formula:
Anyway, in order to create a slicer I need a column and it is also impossible to create a column in direct quiery based on this measure. I also tried to create a custom column in Query Editor by your example but due to those limitations, my formula doesn't work .