Forum Discussion
Dax Calculation
Hello ,
As you seen in the picture above if i select November 2017 it show me November 2017 but what i need to show is from "January to november", if i select March 2019 for exp it should show me "January,February,March" 2019, my formula it's above in the picture, can any one help please ? thank you
FZOU Hard to say exactly what is going on. My guess is that your Date table has a relationship with a date column in your Treasury table. In looking at your code, the November value *should* be returning the sum of Totaly Payment EUR for the entire year through November because you have your ALL statement in there. However, it seems like you want to have the other month columns displayed as well as November. You could try disconnecting your date table or having another disconnected date table for your date slicers and that might do the trick.
If that doesn't help, 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.
1 Reply
FZOU Hard to say exactly what is going on. My guess is that your Date table has a relationship with a date column in your Treasury table. In looking at your code, the November value *should* be returning the sum of Totaly Payment EUR for the entire year through November because you have your ALL statement in there. However, it seems like you want to have the other month columns displayed as well as November. You could try disconnecting your date table or having another disconnected date table for your date slicers and that might do the trick.
If that doesn't help, 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.