Will the months change dynamically?? When i used 0 i was getting all trues so i tried with -2 then my data got matched,when i move from july to August month will this measure work dynamically?? Thank you
Possible if you have only a single date column in the sales table. Imagine a sales table with 3 date columns : Sales Date, Delivery Date, Refund Date (if refunded), in those cases you're somehow forced to make a longer calendar table than the last date of sales date.
Hi It looks out of the context but I wanted to know if is it possible that can we 've Month on month %change of count even if we just have one month data and next month data is yet to get updated ?
Thank you for all of the content you provide. For those of you who have not purchased Chandeep's courses, I totally recommend them. Chandeep: I am thinking about purchasing the Mastering DAX in Power BI course. What's the difference between that and Mastering DAX and Data Modeling (which I already purchased)?
Dear chandeep, In this video, you proposed as a solution the addition of a calculated column in the date table. It would be interesting to have a video, a version 2 of the proposed solution, with a DAX measure, perhaps with a virtual calendar table and with the addition of a calculated column, but in the virtual table, variable of a DAX measure. Greetings
I got here by searching for a solution to this problem - this video is fantastic, so clearly explained with great examples. Thank you. I have subscribed.
Thanks, I've always just use a if total sales Blank etc. , but this is much neater also regarding the use of nested CALCULATE that is something that I never really know if it's needed.
Normally I love your content, especially about PQ but.. this one is just really bad.. Avoid calculated columns people whenever you can and put that check in YTD measure itself.. EZ to pull, and if someone want to know how leave a comment below mine..
I don't out rightly discard calculated columns, especially if they simplify logic and improve performance. The use of calculated columns is very selective case by case.
⬇Download the file used in the video -
goodly.co.in/neat-calendar-table-trick-power-bi
Nice one Chandeep !!
W/O Calc column using measure ;
MEASURE 'My Measures'[Sales YTD2] = TOTALYTD([Total Sales],'Calendar'[Date],
FILTER(
all('Calendar'),
'Calendar'[Date]
Hi.
What wrong with
Calculate( totalYTD(...)
, NOT ISempty(Sales[date])
)
Will the months change dynamically?? When i used 0 i was getting all trues so i tried with -2 then my data got matched,when i move from july to August month will this measure work dynamically??
Thank you
Your videos are gold! Thank you for all your efforts, I learn every time I watch!❤
Calculate wrapped in a calculate?! Greg Deckler would not approve of this 😂
for the same problem, once you used a nested calculate, and the other time you did not. This is quite confusing.
Why not just create a calendar table using MIN and MAX dates of the fact as the date range to avoid this problem altogether?
Possible if you have only a single date column in the sales table.
Imagine a sales table with 3 date columns : Sales Date, Delivery Date, Refund Date (if refunded), in those cases you're somehow forced to make a longer calendar table than the last date of sales date.
Imagine that you have table with plan data that is set in future dates. And you need to track plan and fact. So you need approach from video.
Hi
It looks out of the context but I wanted to know if is it possible that
can we 've Month on month %change of count even if we just have one month data and next month data is yet to get updated ?
Thank you for all of the content you provide. For those of you who have not purchased Chandeep's courses, I totally recommend them.
Chandeep: I am thinking about purchasing the Mastering DAX in Power BI course. What's the difference between that and Mastering DAX and Data Modeling (which I already purchased)?
You have the new one.. don't buy the old one.
FANTASTIC!!! I'll be implementing this ASAP!!!
Thank you, that was an amazing trick and eye opener video.
Dear chandeep,
In this video, you proposed as a solution the addition of a calculated column in the date table.
It would be interesting to have a video, a version 2 of the proposed solution, with a DAX measure, perhaps with a virtual calendar table and with the addition of a calculated column, but in the virtual table, variable of a DAX measure.
Greetings
I got here by searching for a solution to this problem - this video is fantastic, so clearly explained with great examples. Thank you. I have subscribed.
Hi Chandeep, Can't we just create a measure using isempty func with not and apply as filter
How would you do this in Excel Power Query?
Why not create a few variables and wrap it in a
RETURN
IF(
X
),
BLANK()
)
?
Thanks, I've always just use a if total sales Blank etc. , but this is much neater also
regarding the use of nested CALCULATE that is something that I never really know if it's needed.
Total Sales Blank can also be false in a month or week in between the data.
What we really need is display until the end of the last sales date.
Very clever, thanks Chandeep!
Thanks again Chris :)
another class one, thank you for sharing
Thank you Chandeep,
better and better
Super Brother
Nice technique.
Brilliant!
You make my day, again. Thanks!!
Glad to hear that :)
Normally I love your content, especially about PQ but.. this one is just really bad..
Avoid calculated columns people whenever you can and put that check in YTD measure itself..
EZ to pull, and if someone want to know how leave a comment below mine..
Whole day calculated columns are NOTHING for performance, on the other hand billions of fractions of time are a problem like you say.
I don't out rightly discard calculated columns, especially if they simplify logic and improve performance.
The use of calculated columns is very selective case by case.