Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello, any ideas how i would show the following with dax. it would be Apri to current full month in fiscal year. so it would be April - Oct.
@NewbieJono Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
sorry for not explaining my self. i have volumes per month in the data. i would like the compare the fiscal year to date for precious years also.
so:
April 2022- Oct 2022 - Total Volume
April 2021- Oct 2021- Total Volume
April 2020 - Oct 2020 - Total Volume
etc
October would need to be current month - 1, for example in december the data above would show April - dec for current and prevuous years
User | Count |
---|---|
89 | |
85 | |
66 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |