Forum Discussion

ThisIsBlecki's avatar
ThisIsBlecki
Frequent Visitor
1 year ago
Solved

Wrong Value for Rolling/KPI When Adding Time to Visual

Hi everyone,   I’m facing an issue with a KPI in Power BI that uses a Calculation Group to calculate both a rolling 12-month value and a cumulative YTD value. The KPI visual in Power BI requires a ...
Need Help
Tutorial Requests
  • ThisIsBlecki's avatar
    ThisIsBlecki
    1 year ago

    Hi v-sshirivolu , 

     

    Unfortunately, it didn’t work. Power BI applies a strange time filter that I can’t make sense of. Unfortunately, I can’t find a solution without Tabular Editor and DAX Studio.

     

    I’ve moved the entire calculation logic to the data warehouse.

     

    Thanks for your help, and sorry for the late reply — I was away.

     

v-sshirivolu's avatar
v-sshirivolu
Community Support
1 year ago

Hi ThisIsBlecki ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution and give a 'Kudos'. This will be helpful for other community members who have similar problems to solve it faster.

 

Thank you

ThisIsBlecki's avatar
ThisIsBlecki
Frequent Visitor
1 year ago

Hi v-sshirivolu , 

 

Unfortunately, it didn’t work. Power BI applies a strange time filter that I can’t make sense of. Unfortunately, I can’t find a solution without Tabular Editor and DAX Studio.

 

I’ve moved the entire calculation logic to the data warehouse.

 

Thanks for your help, and sorry for the late reply — I was away.

 

  • v-sshirivolu's avatar
    v-sshirivolu
    Community Support
    1 year ago

    Hi ThisIsBlecki ,

    Thanks so much for the update and no worries at all about the delay!

    ISince the entire calculation logic has been moved to the Data Warehouse and the issue appears to be resolved, I’ll go ahead and close this thread. With the changes in place and no further action required, this thread will be closed.

    regards,
    Sreeteja