Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |