Forum Discussion

ManuApo's avatar
ManuApo
Icon for Helper II rankHelper II
3 years ago

Struggling to create Measure :( Please help!!

Hi community,  I am really struggling to create a measure that basically shows the StatusID every day in a date calendar until it changes. My dataset has some IDs with different StatusID that chan...
DAX
Measures
tricks and tips
ManuApo's avatar
ManuApo
Icon for Helper II rankHelper II
3 years ago

Hi   Greg_Deckler  thanks for your reply and your time. 

Unfortunately it didn't work. 




I want my measure to fill up every cell in the matrix with the current status for every calendar date until it changes. The end point will be to apply a background color to each status ID so I can track the changes easily.

Any ideas? 

FYI - I have removed the ALL function from the formula because I am appliying a filter on the page. 

  • ManuApo's avatar
    ManuApo
    Icon for Helper II rankHelper II
    3 years ago

    Hi Greg_Deckler  I am not sure if you saw my last reply. Hope you can help me with this. 

    Thanks in advance!!

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      3 years ago

      Hi, ManuApo 

      Are you referring to using the state ID to fill all nulls of the matrix?

      Not fully sure about your needs, please share a sample file for further research.

      Best Regards,
      Community Support Team _ Eason

       

      • ManuApo's avatar
        ManuApo
        Icon for Helper II rankHelper II
        3 years ago

        Hello v-easonf-msft 

        Thanks for your reply! Yes that is what I am after. I want to fill all null values with the corresponding state ID on each date.