Set Analysis not working because of single digit month

[Applicable88]

Hello, 

I'm using a set analysis to sum the sales of a table like this:

Sales	Year1	Month1
1234	2021	01
2321	2021	01
1231	2021	01
32123	2021	02
12312321	2021	03
123123	2021	03
7676578	2021	04

It took me a while to find the problem, since it worked out last year. So I just realize when I finished that App it was from October on. And from October on, we have two digit Month i.e. 10-12

It works out without problem for my num(year(today())) part. But not for month:

Sum({1<Year1={"$(=num(year(today())))"},Month1={"$(=num(floor(month(today()))))"}>}[Sales]))

So when I now just put the  num(month(today())) in a KPI Window the number of today's month won't display as "01" but as "1".

So I guess for set analysis 01 is not the same as 1? 

I hope someone knows a workaround to this. 

Thanks.

[PrashantSangle]

in your script just do below change

num#(Month1) as Month1

Regards,

Prashant Sangle

[Frank_Hartmann · Accepted solution]

try this:

num(month(today()),'00')

[Ksrinivasan]

Hi,  are you sure,  was single digit month cause of problem? It happened to me also. But first two days or considered as date, 3rd and forth day was not considered as date. When two files were merged like CSV and XLS. It was formed like that. Pl. Confirm that whether single date not shown from single digit date.

Regards,

Ksrinivasan

[Applicable88]

Thank you! That displayed the month as 01 and worked out. 

[Applicable88]

thank you for your tip. It indeed was "one" of the problems. I really needed to make 01=1 work first, to filter the right sales data. But there was really also another mistake that I had to figured out.