Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts
Can not see the wood for the trees....Assume that you have the following data:
Jan 18 10000
Feb 18 5000
Mar 18 2000
Net Sales data...
When the user selects from the slicer Jan and the year 2018 the QTD information. should be just 10000....not the sum of the three months...cannot see the error the the YTD works correctly....
Solved! Go to Solution.
Hi @Anonymous,
Please share your data sample and your QTD formula so that I could test if there is anything wrong with your formula.
Best Regards,
Cherrry
Hi @Anonymous,
More details will be better.
If it is convenient, could you share your formula and your problems?
Best Regards,
Cherry
Hi Cherry
When i select QTD from Slicer i get the full QTD numbers for any month i select. ...
Hi @Anonymous,
Please share your data sample and your QTD formula so that I could test if there is anything wrong with your formula.
Best Regards,
Cherrry
Hi Cherry - thanks for the excellent feedback. I worked out the solution error with my DAX formula.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |