Sales today expression set-analysis

[Anonymous]

Hi guys,

I want to show the sales for the current day/month/quarter/year. In this example, sales is called [Nett Amount].

The following expression in set-analysis works (i.e.) for sales per day:

Sum({1<InvoiceYear={'2017'}, InvoiceDate={'2-1-2017'}>}[Nett Amount])

To make sure that this expression will also be working in the other months/years, I tried for example this expression for my daily sales:

Sum({$<InvoiceDate = {"$(=Date(Today(), 'DD/MM/YYYY'))"}>} [Nett Amount])

This expression is only giving me 0 values.

Could you guys help me out with this one?

Thanks in advance!:)

Mike

[sunny_talwar]

You can also try this:

Sum({$<InvoiceDate = {"=InvoiceDate= Today()"}>} [Nett Amount])

[Anonymous]

Ok! Problem found... There was something with the data and the values I got, were actually the right ones!

So the expression D-M-YYYY was apparently the solution!

Just for my understanding, why is this the date format, when I've made a transformation with DD-MM-YYYY as date format?

[sunny_talwar]

I think DD-MM-YYYY can be use interchangeably... but can you share what's the script you have used?