Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
I am not getting correct t calculated value for previous Month column , For example in below screen shot CM sales for March =3,881,693. in PM Sales column of April month i am expecting 3,881,693.
CM Sales = CALCULATE(SUM('sales'[salesamt]), bcalendar[byear]= YEAR(TODAY()))-- Current Year Sales by month PM Sales = CALCULATE (SUM('sales'[salesamt]),PREVIOUSMONTH(bcalendar[bdate]), bcalendar[biyear]= YEAR(TODAY())) ---Current Year Previous Month Sales
Solved! Go to Solution.
Hi @prasy14,
Please try this:
PM Sales = CALCULATE ( SUM ( 'Sales'[SalesAmount] ), FILTER ( ALLSELECTED ( 'bcalendar' ), 'bcalendar'[bdate].[MonthNo] = MONTH ( MAX ( 'bcalendar'[bdate] ) ) - 1 && 'bcalendar'[byear] = YEAR ( TODAY () ) ) )
Regards,
Yuliana Gu
Hi @prasy14,
Please try this:
PM Sales = CALCULATE ( SUM ( 'Sales'[SalesAmount] ), FILTER ( ALLSELECTED ( 'bcalendar' ), 'bcalendar'[bdate].[MonthNo] = MONTH ( MAX ( 'bcalendar'[bdate] ) ) - 1 && 'bcalendar'[byear] = YEAR ( TODAY () ) ) )
Regards,
Yuliana Gu
You can try:
PM Sales = CALCULATE ( [CM Sales],PREVIOUSMONTH(bcalendar[bdate]) ) ---Current Year Previous Month Sales
Though if it were me, i'd have a 'Year' slicer, to make it easier.
Hello @mattbrice,
i have to display Current Year,Last Year, LLY,LLLY by months as well that is reason i am not using year slicer.
the code which you have provided is giving me blank values.
Does your 'bcalendar' table include dates for the prior month? prior year?
Hi @BILASolution,
Thanks for PBIX file, I still get blank values when i use the DAX and I do have same relationship between the tables as yours
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |