topic Dax in DAX Commands and Tips

Dax

Cyriackpazhe — Wed, 12 Mar 2025 07:27:16 GMT

I want to compute the sales
I want to compute the sales considering the first day of sales only.
1. The the first figure I avoided the Iteration of product table. Why did i not get an output.

2. I Avoided the iteration over the product table again, But the measure gave me an Output.

3. I iterated over the product table. Is it necessary to iterate over product table. What are the issues with first and second measure. Can someone help me out

Re: Dax

Deku — Wed, 12 Mar 2025 07:41:33 GMT

Syntactically the first and second measure are identical. Min( sales[order date] ) == minx( sales, sales[order date]). The only difference is you have wrapped on in calculate, since there is no row context or calculate modifiers it does nothing.

The 3rd is wrong. You are summing the min order dates of each product together

It is not clear why your 1st and 2nd should have differing results

Re: Dax

Cyriackpazhe — Wed, 12 Mar 2025 07:47:45 GMT

The third one is the correct one. I'm summing the sales amount of the product on the first day of sales.

Re: Dax

Deku — Wed, 12 Mar 2025 08:08:26 GMT

You're right, with the formatting on the measure I misread it

Re: Dax

Cyriackpazhe — Wed, 12 Mar 2025 08:13:59 GMT

So my doubt is, is it necessary to iterate over the product table?? Why do i get a different result when i don't iterate over product

Re: Dax

Deku — Wed, 12 Mar 2025 08:18:40 GMT

The first two return a single date for the first order from any product. So you will only get sales from products on that had sales on that day.

When you iterate products you are getting the first sales date, and then the sales amount per product, then summing the results. So this also includes products that have first orders after the very first order date

Re: Dax

v-prasare — Fri, 11 Apr 2025 15:44:46 GMT

Hi Cyriackpazhe,

As we haven’t heard back from you, we wanted to kindly follow up to check if the below solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Re: Dax

v-prasare — Tue, 15 Apr 2025 08:49:36 GMT

Hi Cyriackpazhe, As we haven’t heard back from you, we wanted to kindly follow up to check if the below solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Re: Dax

v-prasare — Tue, 22 Apr 2025 07:10:31 GMT

Hi Cyriackpazhe,

As we haven’t heard back from you, we wanted to kindly follow up to check if the below solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query