Forum Discussion

PowerBIBeginer's avatar
PowerBIBeginer
Helper V
2 years ago

help on sameperiodelast year

Hi All,   I've one Dax which gives me no of volume and have derived with help of Dax. Now problem is, I've 2024 year-month column, i also derived last year 2023 year-month column. infact I've volum...
Need Help
PowerBIBeginer's avatar
PowerBIBeginer
Helper V
2 years ago

Hi Jihwan_Kim.. Appriciate your effort for understanding mu issue exactly well and try to plot across very nicely. I would like to hightlight here something that, Volume Measure you've taken simply sum of one column, even I do that but using one filter condition in that.

for e.g.

volume = calculate(sum(tblname[volume]), tblname[onecolumn]="VC")

and hence I designed Previous year Volume like below but I got blanks..

Previuos year volume = CALCULATE(
                        SUM(tblname[Volume]),
                        tblname[onecolumn]="VC",
                        SAMEPERIODLASTYEAR(tblname[date]))

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

You have not created a calendar Table, as suggested by Jihwan.  Study his solution carefully.

  • PowerBIBeginer's avatar
    PowerBIBeginer
    Helper V
    2 years ago

    Hello Ashish Sir, please refer post no 6 in which I post that I've now used date table and date field even and I got the values but against 2024 2023 value is not appearing