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.
Maybe I am missing something but shouldnt the current for 2017 be the Last for 2018? Here is my code
Current = CALCULATE(COUNTROWS('FactWholesale'))
Last = CALCULATE([Current],SAMEPERIODLASTYEAR('DimDate'[Date]))
578 for 2018 and 594 for 2017 is correct for the current but shouldnt last for 2018 be the current for 2017 which is 594
mething but shouldnt the cu
Hi,
You should not have a year in the Fiscal month column. In the DimDate Table, extract the Month using the =FORMAT([Date],"mmmm"). Drag this Month column in the visual.
I am getting this error mesage
when i do this
Hi,
Share the link from where i can download your PBI file.
I think I know what is going on. Our fiscal month
September 2017 ran from
8/28/2016 - 10/01/2016
fiscal month
September 2018 ran from
8/27/2017 - 9/30/2017.
Our fiscal calendar ends on the last Saturday of the month. Is there a way to get the sameperiodlastyear to work with this type of monthly set up?
For any time intelligence function, you could implement a custom DAX formula.
https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/
I do not know how to share the link to my PBIX without sharing all of my work, which I do not want to do.
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |