Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Compare the missing values between two dates in a single table

Hi,

My request is below;

 

From this table I want compare the values missing beween two dates. I want to populate the numbers as well as the values. Date I want to have a slider so based on min and max date from the slider, the data should populate.

Example 1: Let's say my min date in slider is 1/1/2019 and max date is 1/3/2019. For this the missing value is 5.

Example 2: Let's say my min date in slider is 1/2/2019 and max date is 1/3/2019. For this the missing value is 3.

 

Please suggest.

 

Thanks in Advance!

Need Help
Show and Tell
Tutorial Requests

7 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi,

    Please check the below measure and picture, and please let me know whether it is what you needed.

    I also added a link to the pbix file below.

     

    Missing Values Count =
    VAR daysinperiod =
    COUNTROWS ( dates )
    VAR newtable =
    GROUPBY (
    Data,
    Data[Value],
    "@valuegroup", COUNTX ( CURRENTGROUP (), Data[date] )
    )
    VAR filternewtalbe =
    FILTER ( newtable, [@valuegroup] < daysinperiod )
    RETURN
    COUNTROWS ( filternewtalbe )

     

     

    https://drive.google.com/file/d/18fmECiBWs5VWrDveCiB6wsHLOiR_pF0t/view?usp=sharing 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Jihwan_Kim , 

      Thank you for the refrence. But how to populate the values?

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        5 years ago

        Hi,

        Sorry, I forgot to describe the values in the report.

         

        please kindly check the below calculated-measure, and the picture.

         

        Missing Values Show =
        VAR daysinperiod =
        COUNTROWS ( dates )
        VAR newtable =
        GROUPBY (
        Data,
        Data[Value],
        "@valuegroup", COUNTX ( CURRENTGROUP (), Data[date] )
        )
        VAR filternewtalbe =
        FILTER ( newtable, [@valuegroup] < daysinperiod )
        RETURN
        CONCATENATEX( filternewtalbe, Data[Value], ", ")

         

         

        The file link is still the same.

         

        Did I answer your question? Then please mark my post as the solution.
        If I helped you, click on the Thumbs Up 

         

         

        Thank you.