Last answered:

12 Nov 2022

Posted on:

12 Nov 2022

0

Sales last month

I am getting a blank when choosing sales last month. imageCan someone please help me out

11 answers ( 0 marked as helpful)
Posted on:

12 Nov 2022

0

Can you please show me your DAX?

Posted on:

12 Nov 2022

0

image

Posted on:

12 Nov 2022

0

is your dim_Date table connected to the fact_InternetSales table?

Posted on:

12 Nov 2022

0

yes, it is connected image

Posted on:

12 Nov 2022

0

ok, is the total sales amount measure returning the correct results? I can see that you have the correct syntax, a relationship and you have also marked your date table as date table. Are the rest of the measures working, i.e. Previous One Month, etc?

Posted on:

12 Nov 2022

0

No sir rest of the measures are also not working. On page 1 they are working fine but on page 2 they are not working.imageimage

Posted on:

12 Nov 2022

0

I see what the issue is, please select a currency first on your second page, then it should work.

Posted on:

12 Nov 2022

0

No sir It is still not working, I might have to do all these from scratch image

Posted on:

12 Nov 2022

0

It doesn't make sense for the formulas to be working on page one, and not to be working on page two. What does the Total Sales Amount measure look like?

Posted on:

12 Nov 2022

0

Total Sales Amount = SUM(fact_InternetSales[SalesAmount]
This worked on first page but not on second

Posted on:

12 Nov 2022

2

While selecting currency make sure that there is no other filed is selected, check once every filed other than currency and deselect that.
I just hope this will work!

Submit an answer