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 ...
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!

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community 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
      Helper I
      8 years ago

      Hi Zubair_Muhammad

       

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

       

       

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Community Champion
        8 years ago

        Hi idontexist

         

        Please try replacing

         

        VALUES (Local Measure[Measure Quantity])

         

        with

         

        SUM (Local Measure[Measure Quantity])

    • idontexist's avatar
      idontexist
      Helper I
      8 years ago

      Hi Zubair_Muhammad

       

      It also didn't help. But i have figured out how i can do that. It's almost looks like my first formula:

       

      Matrix plan = IF ( NOT ( ISBLANK ( [Compliant Distribution] ) ); CALCULATE(sum('Local Measure'[Measure Quantity]);'Date'[Day Of Month]=1))

       

      It just didn't show me correct values if i use "date" in fields:

       

      But if i add "Day of Month" which i use in formula, instead of "Date" it will calculate as i want. Only without total sum, unfortunately.