Forum Discussion
help on sameperiodelast year
Hi Jihwan_Kim, I used now date table field date column and I got the values, but as per SAMEPeriodelastyear dax, against Jan 2024 its not showing me Jan 2023 value.
belwo is the snip
Hi,
Please share your sample pbix file's link, and then I can try to look into it.
Thank you.
this is the main table from where i pulll volume (i.e.output column)-
in example I purposefully change names.. I cant share pbi file since in transform data more tables are connected to main table (main table my naming conv is tblname)
date table
model view
and here's the dax
Hi,
In the Calendar Table, create calculated column formulas for Year, Month name and Month number. Sort the Month name column by the Month number. To your visual, drag Year and Month name from the Calendar Table.
Hi,
In the Calendar Table, create calculated column formulas for Year, Month name and Month number. Sort the Month name column by the Month number. To your visual, drag Year and Month name from the Calendar Table.
