Ready made time intelligence functions may not work with direct query, but still you can calculate YTD MTD or QTD using base DAX function combinations for Direct query mode. I have posted videos about how to calculate time intelligence functions in direct query, Please check that out.
Great solutions to important dilemmas, especially the one with the calculation groups 👌
Glad you liked it
Excellent, very useful 😊
Glad, you liked it. Thanks for watching
awesome, thank you for sharing
You are most welcome.
Very amazing.
Thanks for watching.
Thanks! How to sort the MTD vs YTD column values that you showed in the first method? Calculation group not letting us sort. Any workaround please?
For sorting you may need to create the Ranking for desired column items based on the requirements
cool.
Thank you
Can you please tell this same solution for direct query mode as time intelligence won't work in direct query mode.
Ready made time intelligence functions may not work with direct query, but still you can calculate YTD MTD or QTD using base DAX function combinations for Direct query mode.
I have posted videos about how to calculate time intelligence functions in direct query, Please check that out.