Forum Discussion

idontexist's avatar
idontexist
Helper I
8 years ago

Repeat values based on other value

Hi all,   I want to repeat values as you can see in column "should be plan". It should be based on column "Fact". If in this column there are any values so plan should be repeated. "Plan" i have 1 ...
idontexist's avatar
idontexist
Helper I
8 years ago

v-chuncz-msft

 

formulae YEAR and MONTH want to get date in format. Not from column.

 

So this isn't working for me :(

  • idontexist's avatar
    idontexist
    Helper I
    8 years ago

    Zubair_Muhammad

     

    Sorry, did not mentioned that before... But all values exist in different tables.

     

    Below screenshot 

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      8 years ago

      Hi idontexist

       

      Actually I gave formula for a calculated column.

       

      EARLIER doesn't work in a MEASURE.

       

      You can share your file via Onedrive or googledrive.

      I will try to help

      • idontexist's avatar
        idontexist
        Helper I
        8 years ago

        Zubair_Muhammad

        Unfortunately i can't do that, because it's a "live" data, not local. Without access you will not be able to see anything, and i haven't such persmissions to give your proper rights. 

         

        Maybe we can use some workaround... Create table with "Plan" that will be repeated for every day of month. So i can use something like: Matrix plan = IF ( NOT ( ISBLANK ([Fact]) ); [Plan])

         

        Anyway thanks for help!