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 ...
Need Help
Show and Tell
Tutorial Requests
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper 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
      Icon for Super User rankSuper 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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Jihwan_Kim , 

        Can we show the values in Tables format and show other details, if available any.