Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I have been struggling on what it is I am missing to compare last year sales data to this year sales data as of today.
when i am puting Measure on data card LYTD show whole month i need Show data as of today now and same issue on MTD Data card Show Please hellp me .
Result show as beloow LYTD = 71.54 as data card and LY MTD SHow 0.14 as on 1 may 2022 as per my data
Please help me
Have been searching the forum for a while but without finding any answers to my questions:
1. I have created a MTD measure but this won't show any values if I don't have a date filter (= this month).
Hi please help
i need MTD sales LY mtd sales Date wise If 20 jun 22 MTD sales and LY mtd 20 Jun
Hi Not working
Hi @shri0025 ,
Here are the steps you can follow：
1. Create calculated table.
2. Create calculated column.
Year = VALUE("20"&""&LEFT('Table'[Month Year],2))
var _mon=RIGHT('Table'[Month Year],3)
3. Create measure.
LY MTD =
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.