Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am using sameperiodlastyear to calculate the total volume produced last year for the associated market. however in the matrix screenshot below i am getting the correcr grand total but the breakout for the market is missing. Am I using the wrong formula?
I have a slicer with date filter between 5/1/2021 to 5/31/2021. I am using the matrix visualization and in columns i am splitting based on Markets from a dim table.
Hi,
If my suggestion did not help, then share the link from where i can download your PBI file.
Hi, @munna825
Is your problem solved? Since there is no error in the code, we need more information to judge.
Can you share some sample fake data and your desired result? So we can help you soon.
Best Regards
Janey Guo
Hi,
In the slicer, ensure that you have selected a Year and Month from the Date Table.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |