Forum Discussion

idontexist's avatar
idontexist
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper 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
Icon for Community Champion rankCommunity 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
    Icon for Helper I rankHelper 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!

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Icon for Community Champion rankCommunity Champion
      8 years ago

      Hi idontexist

       

      Try this MEASURE.

      It works with your sample data

       

      Measure =
VAR FirstValue =
    CALCULATE (
        VALUES ( TableName[Plan] ),
        FILTER (
            ALL ( Tablename ),
            MONTH ( TableName[Date] ) = MONTH ( VALUES ( TableName[Date] ) )
                && TableName[Date]
                    = MINX (
                        FILTER (
                            ALL ( TableName ),
                            MONTH ( TableName[Date] ) = MONTH ( VALUES ( TableName[Date] ) )
                        ),
                        TableName[Date]
                    )
        )
    )
RETURN
    IF ( NOT ( ISBLANK ( SELECTEDVALUE ( TableName[Fact] ) ) ), FirstValue )
      • idontexist's avatar
        idontexist
        Icon for Helper I rankHelper I
        8 years ago

        Hi Zubair_Muhammad

         

        It return me an error. Words in Russian could be translated as "Error during calculating measure...".