Forum Discussion

insandur's avatar
insandur
Icon for Helper II rankHelper II
1 year ago

Measure not working when using in table when other columns added in the table and applied filters

Hi Experts ,   I have table with multiple columns and using measure to get previous month value for selected month "Prev month Qty"   Now this measure doesnot work in the table when i add f...
Need Help
Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
1 year ago

Hi insandur 

 

Try this measure for previous monh calcuation

 

PrevMonth= Calculate(Sum(sales), DateAdd( 'Calendar'[Date], -1, Month))
Or

Prev Month= Calcuate ( Sum( Sales), ParallelPeriod( 'Calendar'[Date],-1, Month))

 

I hope I answered your question!

 

 

insandur's avatar
insandur
Icon for Helper II rankHelper II
1 year ago

Thank you Uzi,

 

I just get total value, and blank rows when i try above method.

 

  • Uzi2019's avatar
    Uzi2019
    Icon for Community Champion rankCommunity Champion
    1 year ago

    HI insandur 

     

    If you dont have contineous date then you may not get the result.

     

    Try to create calendar table then use the same measure.

    Calendar Tabel= Calendar( Min(FC month), Max(FC month))


    Make sure your FC month is date format should not be a text data type.

     

    I hope I answered your question!