Forum Discussion

MSuser5's avatar
MSuser5
Icon for Helper III rankHelper III
3 years ago

Latest month data not showing

Hi All,   Have quick question i have created measure which is showing latest month value (will be May'2023) it's working fine. But when i add employee name in the table it's showing all the months...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Share raw data in a format that can be pasted in an MS Excel file.

  • MSuser5's avatar
    MSuser5
    Icon for Helper III rankHelper III
    3 years ago

    Hi Ashish,

     

    Please find the sample raw data and expect

    ed result. I want to show latest month (default ) top 3 names.. if user required they can select months in slicer.

    NameSalesMonthDate
    AAA112545301/01/2023
    DDD1811601/02/2023
    BB11537301/01/2023
    AAA11535901/03/2023
    CCC1464701/02/2023
    FFFF1373601/03/2023
    DDD1326201/01/2023
    RRR1278401/03/2023
    RRR1277101/02/2023
    TTT1276101/03/2023
    EEE1253301/01/2023
    AAA11220901/04/2023
    EEE1169701/02/2023
    RRR1158301/04/2023
    TTT1107101/04/2023
    EEE999001/04/2023
    FFFF992501/01/2023
    DDD981001/05/2023
    FFFF971601/05/2023
    TTT793401/05/2023
    YYY772301/05/2023
    EEE744001/05/2023

     

    Expected as default resulrt to be :

     

    Thanks for your support.

      • MSuser5's avatar
        MSuser5
        Icon for Helper III rankHelper III
        3 years ago

        Hi Ashish_Mathur ,

         

        Thanks for the update, As same result i want to show only latest month data in the table chart if user required to see any other month then they will select from month sclier.

         

        So how to show default latest month only.

        Thanks,