Using DAX conditional statement in Cross Tabular Pivot.

[Anonymous]

Hi All,

In the below Dataset I am trying to get a solution to the following questions while keeping the Month wise cross-tabulated format of Pivot :

1.  The products which have been billed less than 2 times.

2.  The products which have not billed from the last 6 months (Considering the Last date of Transaction being 31/12/2019).

I am very new to DAX and want to learn the same. I am a little confused if a cross-tabulated pivot will provide the desired outcome. Link to file:- @https://1drv.ms/x/s!Aph8be9g3hZoh1M_gYqcdLNxGgqs

[Anonymous]

Hi there.

Please inspect the file to see how you get what you want and much, much more.

Best

D

[Anonymous]

Hi @Anonymous,

Thanks for the prompt reply. However, I am unable to open the file because of some error that says: object reference not set to an instance of an object.
While searching for the solution, It came out that I need to downgrade the PowerBi App in my system to open the file as per this article on community. 

Any help will be hugely appreciated.

Thanks Again.

[Anonymous]

I have just installed the latest version of PBI Desktop:

Release:
March 2020

Product Version:
2.79.5768.1082 (20.03) (x64)

and the file opens in it without a hitch. I attach it again. If this does not work... then I can't do anything else.

Best

D