Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all!
I need some help.
I have 3 columns in a summarize table (Provincia, Mes(month of the date of the main table, Total).
For each Mes(it is the month of a Date) I have sevaral values for the column "Total" and I only need the value according to the last date of each month.
For example:
For Tarragona I have 217 for December and 222, in this case according to the date I only need the 217 in mi table.
Can anybody help me?
thank you so much!
Solved! Go to Solution.
Hi all! In the end I solved it using Power M Query, I created a table with this 3 columns I need, then I sort them by the date and I add an index.
After that I used this formula in DAX:
Hi all! In the end I solved it using Power M Query, I created a table with this 3 columns I need, then I sort them by the date and I add an index.
After that I used this formula in DAX:
@cgil can you provide some sample data?
new measure = VAR _MaxDate=CALCULATE(MAX([date]),ALLSELECTED([Mes])) RETURN IF(MAX([date])=_MaxDate,SUM([Value]))
Hi! Thank you for your reply but it doesnt fit what I want...
This is my table:
It shows the same... 😥
Any suggestion?
Resumen = ADDCOLUMNS(SUMMARIZE(llamadas, LLAMADAS[Provincia],LLAMADAS[Fecha].[Mes],"Total",LASTNONBLANKVALUE(LLAMADAS[Fecha].[Date],SUM(LLAMADAS[Total])))
you may translate .[Date] into your language.
User | Count |
---|---|
42 | |
27 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |