Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dax Expression

I have table with date wise data,i want to show the value based on month end. If it have value in jan 31st and dosnot have value in feb 28 then i want to show same value in 28 feb. Please help me t...
Dataflow
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Thanks For the response.

    This solution meets 90%  and only issue was i dont want to sum up Quantity.

    ie expected result shown below 

     

    Month  Count

    Jan        1000

    Feb       1000

    Mar       1000

    Apr        500

    May       500

    Jun        500

     

    The above one is based on the file you shared

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 

    Which code did you use in this screenshot? I think you didn't build a relatisonship in above sample. I think you want yo show the QTY at the last day instead sum of the QTY of the whole month. Could you tell me why Jan, Feb and Mar show 2000 in your screenshot? Please show me the result you want by screenshot. 

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

Agreed with you,adding relation  will give same result.

I have one more concern ,i want see visual based on some filters in sample table(Date filter working and others not).

Currently its not working,currently i have filtered  based on QTY.Like this in my table i have customer names,please help to fix this

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous 

Which code did you use in this screenshot? I think you didn't build a relatisonship in above sample. I think you want yo show the QTY at the last day instead sum of the QTY of the whole month. Could you tell me why Jan, Feb and Mar show 2000 in your screenshot? Please show me the result you want by screenshot. 

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Its by my mistake,i added a duplicate row as same as original data for testing .That is the reason its showing doubled amount.

    As you said i want the data as QTY at last day of each month.From your code am getting that result but the issue was i want to filter it by some colums usng slicers.

    I had attache screen shot of my actual data and the code used.

     

    1.This is the report am developing,here i want to filter values by column in Data table.

    But its not considering my filters

    2.Meassure i had used given below

    Latest QTY =
    VAR _LatestNotBlankDate =
    MAXX (
    FILTER (
    ALL ( 'Data' ),
    'Data'[SIM Summary Snapshot: Created Date] <= MAX ( 'Date'[Last Date each Month] )
    ),
    Data[SIM Summary Snapshot: Created Date]
    )
    VAR _LatestQTY =
    CALCULATE (
    SUM ( Data[SIM Count] ),
    FILTER (ALL( Data), Data[SIM Summary Snapshot: Created Date] = _LatestNotBlankDate )
    )
    RETURN
    _LatestQTY
     
    3.Data in the table