Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Power BI DAX command for QTD Line chart issue

Hi,   I would like to get recommendation for the QTD line chart showing Bump after each month ans starting of new month, expected outcome is to see growing as we are calculating cumulative numbers....
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

 

Is it possible to provide the PBIX file attached for the dummy data. The major conflict is happening in this code, when i removed +1 that resolved the issue for the current month drop down but still happening with the May to June. Instead I am expecting cumulative growing numbers so there should not be any drop down. What other function can be used except DatedIFF.

Appreciate your assistance

Cumulative MQL Projection = 
if(
    max('date'[date]) < today(),
        0,
        if(
            max('date'[date]) >= today() && max('date'[date]) <= eomonth(today(),0),
                calculate(SUM('Global MQL Projection'[MQL Projection - Remaining Daily Average])) * (datediff(today(),min('date'[date]),day)),
                calculate(sum('Global MQL Projection'[MQL Projection - Remaining Daily Average])) * calculate(sum('Date'[Day of Quarter]))
        )
)

 

 

 
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

let go of the month concept and instead work with the individual dates in the quarter.

 

Use one of the internet file services to post your sample data.