Forum Discussion

siva54's avatar
siva54
Helper I
4 years ago

Grouping based Selected value

Hi Team,   I'm new to power bi,  kindly help me out for below requirement. I have month-year slicer. If we selected any one of the month, i needed sum of previous month data and current month dat...
Need Help
Need Help DAX
Need Help DAX measure
amitchandak's avatar
amitchandak
Super User
4 years ago

siva54 , if you have date , then you can use time intelligence two get current and prior

 

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))

 

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA

 

 

But if you want more than one month as a legend, then you need an independent table

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

  • siva54's avatar
    siva54
    Helper I
    4 years ago

    Hi amitchandak,

     

    I need based on selected value of Month text.

     

    For example, if we select may 21 then till may 21 in one bar and May 21 in another bar.

     

    regards,

    Siva54