Forum Discussion

irenelitw629's avatar
irenelitw629
Icon for Helper II rankHelper II
6 years ago

Last week amount DAX doesn't work

Hi,   Can someone take a look why my Last week sales amount DAX doesn't work?  Here is the file   What i did first is to create a Weeknum based on raw data Weeknum = SUBSTITUTE(data[WeekInYear_...
Need Help
irenelitw629's avatar
irenelitw629
Icon for Helper II rankHelper II
6 years ago

Thank you amitchandak It works in imported data.

However it is not working when I connected to data source in SAP HANA using direct query.

Is there any way to show last week amount in direct query? 

My data is too huge to export..

irenelitw629's avatar
irenelitw629
Icon for Helper II rankHelper II
6 years ago

Hi @amitchandak,

 

Also, when I use your file and pull in (opportunity) number field. Current DAX doesn't work anymore ( shows blank).

Can you please advice? Thanks a lot!!