Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
Below expression from @amitchandak :-
2) Current Month = Feb 2021 ( I need to add wording Current Month before Feb 2021 )
My PBI file :-
https://www.dropbox.com/s/zbtghyydwxlnvao/PBT_V2021_400%20GL_TI.pbix?dl=0
Paul Yeo
Solved! Go to Solution.
Hi @admin11 ,
Is it like this?
//hardcode
YTD DATE amit =
var _max = MAX('Date'[Date])
var _min = MIN('Date'[Date])
var _a=format(_min, "MMM-YYYY") & " to " & format(_max, "MMM-YYYY") & " SALES BY BRAND_C"
return IF(ISFILTERED('Date'[Date]) || ISFILTERED('Date'[Year]) ,_a,format( DATE(2021,2,1), "MMM-YYYY"))
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @admin11
Play with this number eventhough it is not dynamic
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Thank you for sharing
may be my question no so clear .
actually what I need to hard code the expression , so it will display Feb 2021 amount .
when I see your expression using Today () - some number , mean the amount will change in june
Hi @admin11 ,
Is it like this?
//hardcode
YTD DATE amit =
var _max = MAX('Date'[Date])
var _min = MIN('Date'[Date])
var _a=format(_min, "MMM-YYYY") & " to " & format(_max, "MMM-YYYY") & " SALES BY BRAND_C"
return IF(ISFILTERED('Date'[Date]) || ISFILTERED('Date'[Year]) ,_a,format( DATE(2021,2,1), "MMM-YYYY"))
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |