Need DAX Expression for one of my requirement  [Solved]

Anything related to PowerPivot and DAX Formuale
Kishore G
Posts: 1
Joined: Mon May 27, 2019 4:54 pm

Need DAX Expression for one of my requirement  [Solved]

Postby Kishore G » Mon May 27, 2019 5:28 pm

Hi,

I came across one requirement in which :
i need to bring up a report in which i have to show

-> All the products which has no sales in current month but has sales in previous month.

and wise versa in another report:

-> All the products which has sales in current month but does not had sales in previous month.

Please find below about dimensions and facts for your reference:

Product Dimension
Product ID Product Name
1 A
2 B
3 C
4 D
5 E
6 F
7 G
8 H
9 I
10 J
Sales Fact
Product ID Datekey Amount
1 201901 10
2 201901 20
3 201902 30
4 201903 20
5 201904 14
6 201901 16
7 201902 14
8 201903 19
9 201903 200
10 201904 45
Date Dimension
Datekey Year Month
201901 2019 Jan
201902 2019 Feb
201903 2019 Mar
201904 2019 Apr
201905 2019 May
201906 2019 Jun
201907 2019 Jul
Result Required:
Product Name No Current Month Sales Previous Month Sales
E 14
J 45



Please help in this with DAX Expression or queries to write..

Please let me know if i have to place this query in any of your blog.

Same you can find as an attachment for better view of requirement.

Thanks,
Kishore
Attachments
Product_Excel_.xlsx
(11.21 KiB) Downloaded 12 times

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 7 guests

cron