Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

MTD and Last Year MTD - DAX - DirectQuery

I am using this formula to calculate MTD transaction counts for prior year:   PY Trx = CALCULATE(sum(Daily[Trx]), FILTER( Daily, Daily[Year]=YEAR(max(Daily[Date]))-1 && Daily[Month]=MONTH(MAX(Dail...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I noticed there are some problems with grouping in PowerBI. Now it is working without any changes in my previous calculations.

     

    Thank you for your time and help! 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

I can help you only if you share some data and the expected result.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I noticed there are some problems with grouping in PowerBI. Now it is working without any changes in my previous calculations.

 

Thank you for your time and help!