Hi Guys,
I have an issue which seems to be easy but it's DAX so it isn't :-)
I have similar Table (called "Data") as source:
Added Table to data model then inserted a Power Pivot: count values in column "C" per Date and per Country:
I started to get proper values for previous date but...
Hi,
I need to write a function, which find value from month from previous year:
Below is example of my data (I have year starting from 1992 - but it should not have meaning)
<tbody>
Year
Month
Quater
RepQua
ID
Value
PrevValue
2015
Jan
Q1
FY15Q1
A1B
10
-
2015
Apr
Q2
FY15Q2
B2C
20%
-...
Hello everyone,
I need a way of get the SUM of the previous date, it couldn´t be previuos month because could be a difference of day. I need it for detect how is changing % from the last date.
I need it for POWER BI
Thanks!!
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.