Forum Discussion

erhan_79's avatar
erhan_79
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

increasing day by day table

Hi there ;   i need  your  kind support to calculate below issue on my report  ;   i have a table which one's name is Table A as below at left , i would like to calculate day by day increasing of...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi erhan_79 ,

     

    Would you please refer to the dax below based on the pbix file you provided:

     

    New Table =
SUMMARIZE (
    'Table A',
    'Dimdate'[Date],
    'Table A'[Sales Group],
    "Amount", CALCULATE (
        SUM ( 'Table A'[Amount] ),
        FILTER (
            ALLEXCEPT ( 'Table A', 'Table A'[Sales Group] ),
            'Table A'[Report Date] <= MAX ( 'Table A'[Report Date] )
                && 'Table A'[Billing Type] <> "F2"
        )
    )
)

     

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

     

    Best Regards,

    Dedmon Dai

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

erhan_79 , Try like

 

New Table = SUMMARIZECOLUMNS('Table A'[Sales Group],Dimdate[Date],"Amount1",[Measure])

 

erhan_79's avatar
erhan_79
Icon for Post Prodigy rankPost Prodigy
6 years ago

hi amitchandak  ;

 

it isworking perfect !

 

 just  one more thing i need too ;

 

imagine that there is one column too on my original table called "billing type" ,there is data " F2" in it ,  i want that this calculation that we created will not calculate under column " billing type" includes "F2" .. What i  need to revise now ?

 

 

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi erhan_79 ,

     

    Would you please refer to the dax below based on the pbix file you provided:

     

    New Table =
SUMMARIZE (
    'Table A',
    'Dimdate'[Date],
    'Table A'[Sales Group],
    "Amount", CALCULATE (
        SUM ( 'Table A'[Amount] ),
        FILTER (
            ALLEXCEPT ( 'Table A', 'Table A'[Sales Group] ),
            'Table A'[Report Date] <= MAX ( 'Table A'[Report Date] )
                && 'Table A'[Billing Type] <> "F2"
        )
    )
)

     

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

     

    Best Regards,

    Dedmon Dai

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    erhan_79 , Try like

    Measure = CALCULATE(SUM('Table A'[Amount]),FILTER(all(Dimdate),Dimdate[Date]<=MAXX('Table A','Table A'[Report Date])),'Table A'[Billing Type] = "F2")

     

    Or

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.