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.
Hello All,
I want to return the number of days in July and I used the measure below measure. It returns 30 days instead of 31 days.
Solved! Go to Solution.
If you meant currently selected month then you can use
Days in current month =
COUNTROWS ( VALUES ( Dates[Date] ) )
or
Days in current month = DISTINCTCOUNT( Dates[Date] )
if you meant in July 2020 then
Days in current month =
COUNTROWS (
FILTER (
Dates,
Dates[Month Number] = MONTH ( TODAY () )
&& Dates[Calendar Year Number] = YEAR ( TODAY () )
)
)
@Selded , Try
Days_In_Current_Month = DAY(EOMONTH('Date'[Date],0))
if it is a measure
Days_In_Current_Month = DAY(today(),0))
If you meant currently selected month then you can use
Days in current month =
COUNTROWS ( VALUES ( Dates[Date] ) )
or
Days in current month = DISTINCTCOUNT( Dates[Date] )
if you meant in July 2020 then
Days in current month =
COUNTROWS (
FILTER (
Dates,
Dates[Month Number] = MONTH ( TODAY () )
&& Dates[Calendar Year Number] = YEAR ( TODAY () )
)
)
I am looking for a measure that will return the number of days in any current month. July is now the current month so it should return 31 days, Next month is August , when we enter August it shoukd return 31 day as well.
i tried your suggestions, measure number 3 returned blank days. please explain what the year number is suppose to stand for , as i dont have that in my date table.
A snip of my date table below and also the measure below.
thank you
Hi @Selded ,
The above solution looks correct.
However you can try,
Create a Calculated Column in your Date Table.
YearMonthnumber = FORMAT ( Dates[Date],"YYYYM")
Then create a measure
Days in current Month =
VAR _month =
MONTH (
TODAY ()
)
VAR _year =
YEAR (
TODAY ()
)
RETURN
COUNTROWS (
FILTER (
ALL ( Dates ),
Dates[YearMonthnumber]
= CONCATENATE (
_year,
_month
)
)
)
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
53 | |
46 | |
16 | |
12 |