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.
How do I determine the number of days in a month for each mtd to calculated the Target value?
I need to calcuate the Target value per month and this would be determined by the number of days in each month
Looking for the correct syntax -
if Jan = 31 then target/31 for the target value.
How do I determine the begin and end dates of each month and the number of days within each month?
You could create a separate "Month" table like:
Month,Days January,31 February,28 March,31
etc. and then create a measure to sum the [Days] column.
Not entirely sure what you are going for, a little context and data would help.
is there dax code to create such a table and how do I implent it?
thanks for the suggestion , however, I do I do it in DAX?
I have a field called createDate (dates) How do I use this field in an existing PowerBI Query to count the rows of days per each month worth of data?
Right, in Desktop, use an Enter Data query to build your Month table. Then in your existing table in Desktop create a new column in your data model with a formula like:
MonthName = FORMAT([createDate],"MMMM")
Relate the two tables on the MonthName columns and create your measure.
Alternatively, in M you can use Date.DaysInMonth
https://msdn.microsoft.com/en-us/library/mt260645.aspx
Date.DaysInMonth( DateTime.FromText("2012-03-01")) equals 31
what is the correect syntax for count(datez)????
User | Count |
---|---|
86 | |
84 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |