Dear friends I am facing some difficults to create a index column that will increment 1 each time the value in another column change. Below sample data:
-The "periods" column is the reference, il will keep growing ordenally like the sample and the index column is the way I wanted dax formula to write the index. Could anyone help me with this?
@LelecoLima Please try the following calcualted column
Month = MONTH(DATEVALUE(1&"-"&LEFT(Data[Periods],3)&"- 2016"))
If Feb is written as fev in the default date settings of your computer, then I am hopeful that this should work
@LelecoLima Please try the following calcualted column
Month = MONTH(DATEVALUE(1&"-"&LEFT(Data[Periods],3)&"- 2016"))
If Feb is written as fev in the default date settings of your computer, then I am hopeful that this should work
Helpful resources
Microsoft Ignite
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
The largest Power BI virtual conference
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
