Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Please help me understand:
I have a standard sales plan table. The date column displays only the first days of each of the 12 months. I display the budget amount on a card and create a slice by the date column, which is formed as DateTable = CALENDARAUTO(12).
When I specify a time interval in the slice that includes the first of the month, I get the budget amount. As soon as I set an intermediate date, for example 01/02/2023 - 01/20/2023, the budget data disappears. It is necessary for me, that the budget of month or months falling in the interval of time chosen by me was deduced.
I will be grateful for your help!
Hi @Sergii22 ,
I created some data:
Here are the steps you can follow:
1. Create calculated table.
Date =
DISTINCT('Table'[Date])
2. Create measure.
Measure =
var _mindate=MINX(ALLSELECTED('Date'),[Date])
var _maxdate=MAXX(ALLSELECTED('Date'),[Date])
var _select=
SELECTCOLUMNS(
FILTER(ALL('Table'),'Table'[Date]>=_mindate&&'Table'[Date]<=_maxdate),"Month",MONTH('Table'[Date]))
return
SUMX(FILTER(ALL('Table'),
MONTH('Table'[Date]) in _select),[Value])
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Greetings! Thanks for the answer, but my problem is not solved. I need the values to be displayed when selecting a range within the month as well. For example, if I select January 2 - January 20, the values will not be displayed on the card.
@Sergii22 , that depends on what measure you are using.
In case you use dates* or previous* functions
Why DATESMTD is still blank, even after having correct TI Setup: https://youtu.be/j0ug-XQgZtg
openingbalancemonth, openingbalancequarter, openingbalanceyear: https://youtu.be/6lzYOXI5wfo
Power BI Allocating Targets- closingbalancemonth, closingbalancequarter, closingbalanceyear:https://youtu.be/yPQ9UV37LOU
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
62 | |
51 | |
47 |
User | Count |
---|---|
213 | |
81 | |
64 | |
60 | |
56 |