Forum Discussion

dbrandone's avatar
dbrandone
Helper IV
4 years ago

Historical Daily calculations based on dynamic fields

Hi everyone,   I ran into a roadblock with one request I received from a department. I wanted to see if another set of eyes could shed some light on the possibilities.   The department needs to t...
Need Help
dbrandone's avatar
dbrandone
Helper IV
4 years ago

lbendlin 

This metric is for one of the departments yearly goals. I understand I am pushing the limits, if not over, what Power BI can do, but the database that I have access to is what it is (For now!!). 

 

I decided for a temporary work around by creating a write back to SQL process. I created the equivilant of the DAX measure in Power Query within a duplicated table just for this process. I then built a table in a SQL instance I have and when the report refreshes, if a duplicate is not found, then it writes the data I need, and then the data refreshes on the Power BI end to reflect it. It is working so far, so fingers crossed it holds up well until l find another solution within Power BI or on the database side(not holding my breath).

 

Thanks for your assistance with this

  • dbrandone's avatar
    dbrandone
    Helper IV
    4 years ago

    lbendlin 

    yeah, I figured that into the query I wrote. I have it check for duplicate entries first and if no duplicate found, then write. Else, just return the table without writing.